I am having trouble with my report. Access 2000 1

[FultonCounty]

I need to make a report out of my form. My form is figuring how much money we have in each project. The form takes varous equipment and multiplies the hours by the rate for a total $. Then the form takes all these figures and adds them together for a total amount for all equipment. The process continues with material and then labor. At the bottom of the form it shows a grand total for each catergory (GRD TOTAL EQUIP, GRD TOTAL MATERIAL, GRD TOTAL LABOR). Then it totals these 3 totals for a total cost for the project. When I pull out what information I need on my report (Grand Totals only with the total amount for the entire project) I get a $ 0.00 value amount in my report for all catergories. I have designed these before and have not had a problem. However, I have not designed one quite this big. I also DO know how to put in sums in the design view of my report. What am I missing or overlooking? I also get a $ 0.00 value in my table could I not have design the table correctly? My form runs just fine.
Thanks,
F.C.

 

[jplum]

It sounds like all your calculations are being done on the form, which is the way it should be done. What this means though, is that you will have to recreate those calculations on the report as well because the calculations are not being saved in the table.

You should just create your report the same way you created your form, with all the same calculations.

 

[FultonCounty]

JPLUM,
THIS IS GREAT. BUT IS THERE ANY EASIER WAY TO DO THIS? CAN YOU TELL ME IF THERE IS SOMETHING THAT I DID WRONG DESIGNING MY TABLE OR FORM? JUST ASKING FOR AN EASIER WAY BECAUSE I HAVE ABOUT 50-60 DIFFEERENT CALCULATIONS IN MY FORM
THANKS, F.C.

 

[SgtJarrow]

Is your form based on a query? Are the calculations done in the query and displayed on the form? This would be the way I would set it up....

Then, you just use the same query as the recordsource for the report and boom.....you are done! (as far as the calculations go...you still have to do formatting, etc.) Only two things are infinite, the universe and human stupidity, and I'm not sure about the former. (Albert Einstein)

Robert L. Johnson III, MCP, Network+, A+
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com

 

[FultonCounty]

mstrmagel1768
NO. The form is not based on a query. It is based on a table. The calculations were put in the design form of the form. But would you suggest to do all of your databases this way when using formulas (by putting them in the query)? I have only taken 2-one day seminars on Access 2000. I have been trying to get into my 3rd (advanced) class. They keep cancelling the sessions. I guess I am the only access geek out there?!

 

[SgtJarrow]

FultonCountry,
Not necessarily.....it really depends on the concept.....

In your case, you have a form that does all the calculations.....you not want a report to basically display the same information for printing purposes. In a case such as this, I would have started with queries to get all the results I wanted, then built the form and report off of this query.....

As a quick side note, I only build forms directly from the table only for data input.....if there are to be any calculated fields at all, I will use a query from the table, then build the form off the query....

Back to the problem at hand...you have two options....one I have already suggested, but the other may be easier in this instance....create an unbound report, and put unbound boxes on the report making it appear as you would like it to...then, to get the data, use the OnOpen event of the report and simply do:

Me![nameoffield] = Forms![nameofform]![nameoffield]
so on
and so on

for each of the field you have on the report.....but the form must be open for this to work....so if you have a button to open the report, it must first open the fom, then the report....

By doing it this way, you have the form doing all the math and stuff, and then just using the fields in the rport to display that data...But I would eventually go back and create queries instead and base both the form and report off this...

Good luck and feel free to ask more questions. Only two things are infinite, the universe and human stupidity, and I'm not sure about the former. (Albert Einstein)

Robert L. Johnson III, MCP, Network+, A+
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com