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.
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.