V
V_Ernst
I am running a query and basing the results of that query on a Close Date
field in one of my tables.
I am using the normal expression for date range in my criteria which is:
Between #01/01/2008# And Now()
The table that has the close date field also has blanks because some of the
items do not have close dates. These are considered can be considered open
items.
I am trying to write my expression so that I can pull in all of the data
from this table that has the close date not just the items that fall within
in my date range. This way I can see what's open and what has a close date. I
am thinking I need to use NULL in my expressions but I just don't know how to
phrase it and can't figure it out.
field in one of my tables.
I am using the normal expression for date range in my criteria which is:
Between #01/01/2008# And Now()
The table that has the close date field also has blanks because some of the
items do not have close dates. These are considered can be considered open
items.
I am trying to write my expression so that I can pull in all of the data
from this table that has the close date not just the items that fall within
in my date range. This way I can see what's open and what has a close date. I
am thinking I need to use NULL in my expressions but I just don't know how to
phrase it and can't figure it out.