I have a query that looks like this:
SELECT qryPhysicals.NAME, qryPhysicals.UPC, qryPhysicals.SSN, qryPhysicals.PhysDate, qryPhysicals.YearMo, qryPhysicals.TimeElapsed
FROM qryPhysicals
order by qryPhysicals.TimeElapsed desc
This works fine.
However, if I add a where clause,
SELECT qryPhysicals.NAME, qryPhysicals.UPC, qryPhysicals.SSN, qryPhysicals.PhysDate, qryPhysicals.YearMo, qryPhysicals.TimeElapsed
FROM qryPhysicals
Where qryPhysicals.timeelapsed is not null (or any other value)
order by timeelapsed desc
I get "invalid use of null"
I looked at all of the records, all of them contain values.
Any pointers are greatly appreciated.
Thanks
JM420A