Access 2003 from ealier post...

[Jacob]

I have a qry that brings in accounting information. I need to be able to
pull all inventory to date, to Current. The date field I need to pull from
also has null values. Is there a way to bring in all data as of a certain
date?

 

[KARL DEWEY]

Criteria ---
<=CVDate([Enter date])

 

[Jacob]

That will bring all the records todate, however the null values are not
populating. Is there a way to have those appear as well?

Criteria ---
<=CVDate([Enter date])
--
Build a little, test a little.

I have a qry that brings in accounting information. I need to be able to
pull all inventory to date, to Current. The date field I need to pull
from
also has null values. Is there a way to bring in all data as of a certain
date?

 

[KARL DEWEY]

<=CVDate([Enter date]) OR Is Null

--
Build a little, test a little.

That will bring all the records todate, however the null values are not
populating. Is there a way to have those appear as well?

Criteria ---
<=CVDate([Enter date])
--
Build a little, test a little.

I have a qry that brings in accounting information. I need to be able to
pull all inventory to date, to Current. The date field I need to pull
from
also has null values. Is there a way to bring in all data as of a certain
date?