Lifeseeker
Registered User.
- Local time
- Yesterday, 18:18
- Joined
- Mar 18, 2011
- Messages
- 273
Hi,
I have a partially working parameter query working, as you can see in the attached database. (only 5 records)
The problem seems to be that whenever there is an empty row, the query stops looking further. So in the table, you can see that one of the date cells is left empty intentionally. when ran, the results shown on the report only shows the first record as opposed to all records based on the criteria specified.
Criteria specified was: give me records whose dates range from 1997/1/1 to 2000/1/1.
Is there any way around this?
Any direction or guidance is much appreciated.
I have a partially working parameter query working, as you can see in the attached database. (only 5 records)
The problem seems to be that whenever there is an empty row, the query stops looking further. So in the table, you can see that one of the date cells is left empty intentionally. when ran, the results shown on the report only shows the first record as opposed to all records based on the criteria specified.
Criteria specified was: give me records whose dates range from 1997/1/1 to 2000/1/1.
Is there any way around this?
Any direction or guidance is much appreciated.
