Query to filter data with some dates are null (1 Viewer)

msadiqrajani

New member
Local time
Today, 20:29
Joined
May 11, 2011
Messages
5
Hi,
I have Access table with some null values in date column.

I am trying to filter data based on date and name like date >= 1/1/2010 AND name = "Some Item"
But problem is that, some I need to show data without any date filtering.
So it shows all data with dates and without dates with only name filtering.
I am facing difficulty in this part.

I have set parameter for both filtering in a form.

Many thanks for helping me.
 

John Big Booty

AWF VIP
Local time
Tomorrow, 00:59
Joined
Aug 29, 2005
Messages
8,263
Firstly I trust that you don't actually have fields called Name or Date as both these are reserved words and will surely cause you grief.

Try;
Code:
date >= 1/1/2010 AND name = "Some Item" Or IsNUll(date) AND name = "Some Item"
 

Users who are viewing this thread

Top Bottom