Criteria for empty fields (date/time)

[bosslisa]

I am creating a query with criteria for a dates column. The column cotaining dates in my Table has many empty fields. I want to limit the criteria for my dates to >#1/1/2004#, but I don't want Access to exclude all the empty fields because I want all the data displayed for the purposes of my report.

What do I do? I'm not terribly familiar with Access, so please explain as completely as possible. Thanks in advance!

 

[jeremie_ingram]

So you are looking to pull data by multiple criteria? You can use an OR statement

>#1/1/2004# OR IS NULL

 

[bosslisa]

criteria- multiple date columns w/ corresponding data

Thank you!! One more question:
I have multiple date columns in my query. Each date column corresponds to a column of $ amounts. I want each to only display results >#1/1/04#, but I don't want Access to exclude the entire record, just the date and corresponding $ amount from the preceeding column (because for some of my records one date and $ amount is dated after 2004 while another is dated before).
Does this make sense?

 

[jeremie_ingram]

Not really.
Are you stating that you want to basically pick and choose data from different coulmns?
Sounds possibly like you may have an issue with your table structure. Sounds as if the table is flat and not normalized.