Invalid Use of Null

[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

 

[John Vinson]

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".

Please open the query that's generating the error in SQL mode. Trying
to duplicate the query grid in a message falls victim to word wrap -
it's all but impossible to tell what the query is. SQL may look like
gibberish but once you know it it's clearer than the grid!

I suspect that your calculated expressions involve one or more fields
which don't have any data defined - and you're trying to do something
with a NULL that is, well, invalid.