Access reports

S

Shannon

I have set up a table and entered info into a form in
access. Now when I go to run a report, the numbers I
entered do not show up. I have set up formulas in the
form to calculate total hours, total pay, etc., but when
the report is done, it is not showing the number in these
fields. Can anyone help. I am in a bind and ready to
pull my hair out.

Thanks,
Shannon
 
K

Ken Smith

Setting up formulae on a form will only display the result
on the active record's form. The results are not saved to
the table, unless you use the Setvalue function in either
Code or a Macro to save the results to a specific field.

Another way to get the results on the report is copy and
paste the text boxes from the form onto the report design.
Running subtotals and grandtotals from those text boxes
may prove a challenge.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top