I got a lil' problem with "Between" criteria

  • Thread starter Thread starter eamadsen
  • Start date Start date
E

eamadsen

I've got multiple values being queried by parameters like so:

as seen in the GUI design View
Like "*" & [Enter Parameter Here:]
[i:13d3e5cfc5](Office, name,
etc...)[/i:13d3e5cfc5][b:13d3e5cfc5] & "*"[/b:13d3e5cfc5]

Now, one of these values (Date, to be specific), I want to query for
range, and so I type:
[b:13d3e5cfc5]Between [Enter start date:] And [Enter end
date:][/b:13d3e5cfc5]

Now, this works, but with one problem: When I DON'T enter the ranges,
it still queries. I mean, I think it still queries. I just get one
blank record returned. Maybe it doesn't. If anyone's seen this, or can
give me an indication why this may be happening, let me know.
 
This is a flaw when using parameter queries. When you don't enter anything,
the criteria gets interpreted as "Between And", which isn't a real criteria
so it doesn't find anything. What would you like it to do when you don't
enter anything?

Kelvin
 
Back
Top