Access 2003 from ealier post...

  • Thread starter Thread starter Jacob
  • Start date Start date
J

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?
 
That will bring all the records todate, however the null values are not
populating. Is there a way to have those appear as well?


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


Jacob said:
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?
Click to expand...
Click to expand...
 
<=CVDate([Enter date]) OR Is Null

--
Build a little, test a little.


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


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


Jacob said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top