Form to Query

  • Thread starter Thread starter Kim
  • Start date Start date
K

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?
 
Why use subforms to do the math when it can be done in queries and then
viewed in a subform?
 
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".
 
I need to be able to edit/add information from the form. Can I do that if the
information comes from a query?
 
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?
 
I need to be able to edit/add information from the form. Can I do that if the
information comes from a query?
Click to expand...

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.
 
Back
Top