I was wondering if anyone is aware of a lesson/seminar that might help with the following. I have a subform with a calculated total field. I would like to have Access take this totaled value and put it into a query or table field so I can use it in a report with other fields from the same table or query. I am having difficulty trying to figure out how to get this value to a query. All the line items I have are in the table I am using for the subform but I need the total from this subform. I think it would be similar to a calculated invoice total being used to prepare an invoice. I guess the issue is - is it possible to take a value from a form to populate a query or table?
Hi James. Sure, you could do this in several ways. Generally, however, I don't recommend storing values in a table that can easily be calculated elsewhere. An order total, for example, can be calculated using DSum pretty much anywhere in the database. There are exceptions, but that's the general rule.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 9.
