J
jwrnana
I have 2 tables that were already created for me when I opened the order
entry database provided with access. On each of these, I get "Invalid Use
of Null".
Receivables Aging Query: (7 fields as listed below w/table beneath)
Ship CompanyName Account# FreightCharge SalesTax
Orders Customer Customer Orders Orders
Line: Sum(CLng([quantity]*[UnitPrice]*(1-[Discount])*100/100)
Expression
Total Payments
Sum of Payments Query
The Aging Report prints okay.
Customer Sales Query: (6 Fields as listed below w/table)
Customer ID OrderDate FreightCharge SalesTax
Orders Orders Orders Orders
TotalSales Sum(CLng([quantity]*[UnitPrice]*(1-[Discount])*100/100)
Expression
TotalUnits:Quantity
Order Details
SUM
Customer Sales Report will not run -- I get run time error 2101.
Please advise. Thank you, Joy Rose
entry database provided with access. On each of these, I get "Invalid Use
of Null".
Receivables Aging Query: (7 fields as listed below w/table beneath)
Ship CompanyName Account# FreightCharge SalesTax
Orders Customer Customer Orders Orders
Line: Sum(CLng([quantity]*[UnitPrice]*(1-[Discount])*100/100)
Expression
Total Payments
Sum of Payments Query
The Aging Report prints okay.
Customer Sales Query: (6 Fields as listed below w/table)
Customer ID OrderDate FreightCharge SalesTax
Orders Orders Orders Orders
TotalSales Sum(CLng([quantity]*[UnitPrice]*(1-[Discount])*100/100)
Expression
TotalUnits:Quantity
Order Details
SUM
Customer Sales Report will not run -- I get run time error 2101.
Please advise. Thank you, Joy Rose