Form to Query

[Kim]

I am currently creating a master form called "Client Form." Within the Form
there are several subforms that pull data from various tables, all linked by
the name of the client. I used equations within the subforms in order to
average, subtract, and multiply data within the tables. I am now trying to
Create a query or some tabular way of viewing this new information, with the
new calculations. Is this possible?

 

[KARL DEWEY]

Why use subforms to do the math when it can be done in queries and then
viewed in a subform?

 

[Dorian]

Yes but it depends on if this data is to be from one subform or from many
subforms.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[Kim]

I need to be able to edit/add information from the form. Can I do that if the
information comes from a query?

 

[KARL DEWEY]

I would not think you would be editing data at the same time you are pulling
that data for calculations.
Normally data entry/editing is done separately for data pull/reporting.
Why must you pull for editing and calculations at the same time?

 

[John W. Vinson]

I need to be able to edit/add information from the form. Can I do that if the
information comes from a query?

Sure, so long as it's an updateable query and so long as you're not trying to
update the calculated field.

Most queries are updateable; Totals queries, Union queries, and some
multitable queries aren't, but if you just need a query to select a subset of
the fields, or apply criteria, or sort the data, it should work fine.