Owners'IncomeQuery:
I need to get rid of this paramret box as it is not supposed to be there. I have searched online videos and cant get rid of it.
I just need a caluclated field - Income: [Price Per Day]*[Rental End Date]-[Rental Start Date], the results are coming up with #NUM
same thing with TopCustomers
Same thing with TopGrossingVehicles
I wrote:
Gross Income:
, but it is not giving me the grand total, just price per day.
same thing with:
CustomerRentalSummaryforRprt
Once the parameter values get fixed in Owners'IncomeQuery & CustomerRentalSummaryforRprt, that will fix the data for both reports.
I have a dummy test I been working on to try and perfect it, attached.
Bookmarks