Form Query

[mrenshaw]

I have a form where you enter customer orders. You can enter multiple items. I have a field that sums the order. The total it not stored in a table, only on the form. I now need to query all orders for the year but can not get totals to show because the formula is in the form. I know this must be simple but I am drawing a blank. Help!

 

[Fizzio]

You can perform a similar calculation in the query but this will most likely total all the orders. You can create a report using the report wizard that will allow you to subgroup your data, show totals for each order and a grand total (or whatever other groupongs you want)

 

[mrenshaw]

Thanks! It worked!