Simple task (1 Viewer)

A

ankrumc

Registered User.
Local time
Today, 03:02
Joined
Feb 23, 2009
Messages
42
I just want a query to only allow records with dates, so if it has a date, it shows up. If not it doesn't.

Thanks!
 
CraigDolphin

CraigDolphin

GrumpyOldMan in Training
Local time
Today, 01:02
Joined
Dec 21, 2005
Messages
1,582
In the criteria row for the field containing the date, type...

Is Not Null

...then open the query. It should have what you want.
 
You must log in or register to reply here.

Similar threads

M
Date on query
Replies
5
Views
177
ebs17
E
MattBaldry
Query Error in List Box
Replies
2
Views
158
MattBaldry
MattBaldry
U
Adding up counted records to get a total
Replies
11
Views
188
UltimateNeo
U
M
Show all records of no criteria value enter
2
Replies
33
Views
721
moi
M
T
Query to find records not between two dates
2
Replies
24
Views
1,661
Pat Hartman
P

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Top Bottom