Hi,
I have a couple of text boxes that set a date range for a query underlying the continuous form I am working on. I got that working and everything was fine.
Then I realized that I need to be able to query on additional criteria (a Job Number) as well. So I created a text box to enter a job number as well. At first I had the problem of it returning no records when the job number field was left blank. So, I added the "OR txtJobNumber Is Null" in the criteria, but that caused the form to return ALL of the records regardless of the date range.
If txtjobno is left blank I want the query to return all the records that fall within the date range regardless of job number, but not all of the records regardless of date range.
Any help would be appreciated. Thanks in advance.
Dan
I have a couple of text boxes that set a date range for a query underlying the continuous form I am working on. I got that working and everything was fine.
Then I realized that I need to be able to query on additional criteria (a Job Number) as well. So I created a text box to enter a job number as well. At first I had the problem of it returning no records when the job number field was left blank. So, I added the "OR txtJobNumber Is Null" in the criteria, but that caused the form to return ALL of the records regardless of the date range.
If txtjobno is left blank I want the query to return all the records that fall within the date range regardless of job number, but not all of the records regardless of date range.
Any help would be appreciated. Thanks in advance.
Dan
