FORM TOTAL DO NOT SHOW UP IN TABLES OR REPORTS

[FultonCounty]

I need help with one of my databases. I have everything running correctly in the form. The form is very large and it has a lot of formulas in it. Basicly it looks like an invoice. However when I go to make a report my totals do not come up. The amounts show $ 0.00. I know there is a simple way to fix this. I must have done something wrong when I designed my table because the totals in the table also come up with $ 0.00. My form runs perfectly and all the totals show up in that view. Can you please tell me? What I am doing wrong?

 

[JeremyNYC]

You'll have to use the same formulae in the reports. The idea is that you don't store calculated values in tables, you always calculate them on the fly. This means you'll have to calculate them in every object in which you want to display them. You can copy and paste controls between forms and reports, so that should ease the pain some.

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.