Query Help 3

[angels2]

I am creating a query and want everything from 4/01/2004 to appear but also blank boxes to be included also I have set a formula for >4/01/2004 but I also want to incude blank boxes thanks in advance for ant help

 

[lespaul]

blank boxes of what?

Leslie

 

[angels2]

I have a helpdesk database and I want to problems that are closed are given a date problems still open the box is blank I want to include all of the data from 4/01/2004 til 9/30/2004 and also any open problem which will be the empty boxes

 

[lespaul]

how is your table structured?

Leslie

 

[angels2]

I am new to access what do you mean about how is my table structured

 

[lespaul]

the field names in your table, the name of your table, how the fields in this table relate to any other tables, what information from your table you want to show up in your query results, and what you want your results to look like.


Leslie

 

[JonFer]

Your criteria for the date should be the following to include the "blanks" which have a Null value:

>=#4/1/2004# Or Is Null

You can also use this to find open issues or those resolved within the last 60 days (for example):

>=Now()-60 Or Is Null


John

http://www.interautomateconsulting.com

 

[lespaul]

now that you have answered the question, the question makes sense, but I couldn't "translate" blanks correctly.

leslie