Validate "Between" Query for a report

P

Pete Sperling

I'm using Access 97

I have a query that has the following Criteria:

Between [Enter Start Year Week ie 0401] And [Enter End Year Week ie 0406]

Problem: I need to be able to ensure that no records are returned if I enter
an invalid (non exsistent) Year Week. Currently I will get records back if
only one of the entries exsists. How can I add "And IsNotNull" in a way that
will affect both entries?

I'm not too experienced in writing expressions - any help greatly appreciated.
 
D

Duane Hookom

Consider the second method from Allen Browne's report tips site
http://members.iinet.net.au/~allenbrowne/casu-08.html.

--
Duane Hookom
MS Access MVP
--

Pete Sperling said:
I'm using Access 97

I have a query that has the following Criteria:

Between [Enter Start Year Week ie 0401] And [Enter End Year Week ie 0406]

Problem: I need to be able to ensure that no records are returned if I enter
an invalid (non exsistent) Year Week. Currently I will get records back if
only one of the entries exsists. How can I add "And IsNotNull" in a way that
will affect both entries?

I'm not too experienced in writing expressions - any help greatly
Click to expand...
appreciated.
 
Top