If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
criteria for an empty date
Hi,
History: In my database I fill in a record for a product but not the date field until the product is completed. My reports will not show this data because I enter a criteria of Like "*/*". What I want to do is have a query that will show me only the records that don't have the date filled in so I can keep track of which ones have been entered and which ones haven't. Question: How do I write criteria that will give me only the empty dates? I have tried Not Like "*/*" but it doesn't work. I don't get any records returned and I have at least three with empty dates. Thanks for your help, June |
#2
|
|||
|
|||
Where NameOfDateField IS NULL
-- Brendan Reynolds (MVP) http://brenreyn.blogspot.com The spammers and script-kiddies have succeeded in making it impossible for me to use a real e-mail address in public newsgroups. E-mail replies to this post will be deleted without being read. Any e-mail claiming to be from brenreyn at indigo dot ie that is not digitally signed by me with a GlobalSign digital certificate is a forgery and should be deleted without being read. Follow-up questions should in general be posted to the newsgroup, but if you have a good reason to send me e-mail, you'll find a useable e-mail address at the URL above. "June" wrote in message ... Hi, History: In my database I fill in a record for a product but not the date field until the product is completed. My reports will not show this data because I enter a criteria of Like "*/*". What I want to do is have a query that will show me only the records that don't have the date filled in so I can keep track of which ones have been entered and which ones haven't. Question: How do I write criteria that will give me only the empty dates? I have tried Not Like "*/*" but it doesn't work. I don't get any records returned and I have at least three with empty dates. Thanks for your help, June |
#3
|
|||
|
|||
In the Criteria row of your query, under the date field enter:
Is Null -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "June" wrote in message ... Hi, History: In my database I fill in a record for a product but not the date field until the product is completed. My reports will not show this data because I enter a criteria of Like "*/*". What I want to do is have a query that will show me only the records that don't have the date filled in so I can keep track of which ones have been entered and which ones haven't. Question: How do I write criteria that will give me only the empty dates? I have tried Not Like "*/*" but it doesn't work. I don't get any records returned and I have at least three with empty dates. Thanks for your help, June |
#4
|
|||
|
|||
Thank you, that worked. And it was so easy too.
June "Allen Browne" wrote: In the Criteria row of your query, under the date field enter: Is Null -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "June" wrote in message ... Hi, History: In my database I fill in a record for a product but not the date field until the product is completed. My reports will not show this data because I enter a criteria of Like "*/*". What I want to do is have a query that will show me only the records that don't have the date filled in so I can keep track of which ones have been entered and which ones haven't. Question: How do I write criteria that will give me only the empty dates? I have tried Not Like "*/*" but it doesn't work. I don't get any records returned and I have at least three with empty dates. Thanks for your help, June |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Countif two criteria - Date and vendor | John | Worksheet Functions | 6 | August 4th, 2004 11:19 PM |
Contract Expires 1st of 6th Month after Date entered! | Wayne | Worksheet Functions | 14 | December 31st, 2003 07:23 AM |