Access: Calculated field from a form getting it to a table.

R

Roger

How do I apply data from a calculated field in a form, or a query for that
matter, to a table.

My calculation is too complex to run reports. I can figure out how to do it
in a query and if I just run the query so that it lists the results the
calculated data works.... but if I use it in a report the program deems it
too complex.
 
A

Allen Browne

Roger, if it works okay in the query, can't we just base the report on the
query?

Or is it possible to create another query into the first one, and use that
as the source for the report?

If there is no way to do that, you could use a temp table as the source for
the report. Create a table to hold the results of the query. Change the
query to an Append query, and run it before the report opens (after a Delete
query that clears the table out.)
 
Top