I am creating a Database for my job and I have created a summery query that individually takes the sum of two expenses (sum of advance and sum of liquidation) and then I created columns to find the totals of these two sums (total amount owed = sum of advance + sum of liquidation) by using Builder. I then created a report based off of this information.
Every time I run this query and report, a Enter Parameter Value box appears. I click OK and the query shows the all the values but the report does not show the sum of advance and sum of liquidation values. I have even created a macro to open the query and the report and then I have SetWarnings No.
I need help preventing the Enter Parameter Value box from appearing. Also, I do not know how to write code, so if it could be as simple and easy as possible that would be very appreciated.
This is the code I have:
DoCmd.OpenQuery "Payment Query", acViewNormal, acReadOnly
DoCmd.OpenReport "Payment Report", acViewReport, "", "", acNormal
DoCmd.SetWarnings False