M
Michelle
I'm using Access 2002, and haven't worked in it for years so I'm really
rusty. I'm setting up a simple accounts receivable database that will print
statements. I've finally made it to the report stage. I have 2 separate
queries that add up the total invoices and total payments. When I try to do
a simple formula to subtract the payments from the invoices:
=[Kin's Total]![Sum of Invoice Total]-[Kin's payment total]![Sum of Cheque
Amount]
It behaves like I'm asking for parameters. The report does work on date
parameters, so when I run the report, it asks for the start and end date of
the report and then asks for Kin's Total and Kin's payment total. How do I
change this from a parameter to a calculcated formula.
Thanks for any help you can offer.
Michelle
rusty. I'm setting up a simple accounts receivable database that will print
statements. I've finally made it to the report stage. I have 2 separate
queries that add up the total invoices and total payments. When I try to do
a simple formula to subtract the payments from the invoices:
=[Kin's Total]![Sum of Invoice Total]-[Kin's payment total]![Sum of Cheque
Amount]
It behaves like I'm asking for parameters. The report does work on date
parameters, so when I run the report, it asks for the start and end date of
the report and then asks for Kin's Total and Kin's payment total. How do I
change this from a parameter to a calculcated formula.
Thanks for any help you can offer.
Michelle