Query display???

  • Thread starter Thread starter rblivewire
  • Start date Start date
R

rblivewire

Is it possible that if a a query asks the user to input a specific
date, that there is something that the user can input to display ALL
query matches regardless of what the date that the query asks for?? I
have a query where is asks the user to input a value such as "0-1
month," "1-3 months," "3-6 months,"6-12" months," and "12+ months." Is
there a way that when it asks for these, the user inputs something so
that ALL matches for these ALL dates show up??
 
Like [Enter Date or Leave Blank for All] & "*"

The Like statement does have it's problems as if someone types in just "1"
it could well meet both your "1-3 months" and "12+ months."

Also if you have lots of records, say in the tens of thousands, the Like
statement might stop an index, providing there is one, from working on this
field thus slowing things down.
 
Back
Top