Access reports

  • Thread starter Thread starter Shannon
  • Start date Start date
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
 
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.
 
Back
Top