Form question

[Amin]

My question is how do you input multiple tables/queries into one form? What I
am trying to do is build ONE form (or maybe I should be using a report?)
where it will show you the amount of work per hour using a chart (which I
have done), AND a Totals Box using a different query that shows the total
amount of work done by the department. While showing me how one query can do
both of these things would be very cool and appreciated, I am more interested
in how to put multiple objects in one form. Thanks so much!

Regards,
Amin

 

[Klatuu]

You can have only one recordsource for a form. It can be a query that joins
multiple tables; however, when you do, there is a good chance you will
create an uneditable recordset. That is, you will not be able to make any
changes to the data. If your form is only for displaying the information,
that should not matter.

 

[John W. Vinson]

My question is how do you input multiple tables/queries into one form? What I
am trying to do is build ONE form (or maybe I should be using a report?)
where it will show you the amount of work per hour using a chart (which I
have done), AND a Totals Box using a different query that shows the total
amount of work done by the department. While showing me how one query can do
both of these things would be very cool and appreciated, I am more interested
in how to put multiple objects in one form. Thanks so much!

Regards,
Amin

If you just want to *display* the data, a Report (which gives you multiple
levels of Sorting and Grouping) may be your best bet; you can display a report
in Preview mode on the screen as well as printing it.

On a Form, you may be able to use a form with one or more subforms, or a
control on the form footer summing values in the form's recordsource... there
are many ways to do this, and which is best depends on your table structure,
your business needs, what tools you're familiar with, and personal preference.

 

[Amin]

Thanks to everyone. Querying is so much more fun. OK, so I guess a report is
the best method for me to use. But the problem is the same as before, how do
I add additional objects into the report?

Thanks,
Amin

 

[Clif McIrvin]

Thanks to everyone. Querying is so much more fun. OK, so I guess a
report is
the best method for me to use. But the problem is the same as before,
how do
I add additional objects into the report?

Thanks,
Amin

As John said, there are many different methods to choose from.

As best as I recall your OP, I believe you could start with either a)
building a Query that combines the different recordsources you are
interested in, or b) using a report (or form) with sub-report(s) (or
sub-form(s)).

To get more specific help here you really need to provide specific
detail instead of asking general questions. The volunteers here are
really, really good at what they do with Access; but they are not
mind-readers!

Research using sub-reports and sub-forms, etc., and come back here when
you have trouble understanding what you've researched or cannot get it
to behave as expected.