Between/And statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Access 2003
I was given a database that was created by someone else years ago to try to
correct a small problem. There is a search commend button (done as an event
- not a macro). The search asked you for a "beg size range" and an "ending
size range" for a particular product. I think I found the query that this is
hooked to. The query only has this between/and statement once, but the
questions come up twice. Can anyone suggest how to find out what is
happening? Why would access asked for this range twice?

Aurora
 
Aurora said:
I am using Access 2003
I was given a database that was created by someone else years ago to try to
correct a small problem. There is a search commend button (done as an event
- not a macro). The search asked you for a "beg size range" and an "ending
size range" for a particular product. I think I found the query that this is
hooked to. The query only has this between/and statement once, but the
questions come up twice. Can anyone suggest how to find out what is
happening? Why would access asked for this range twice?

Aurora
Click to expand...

Guessing... does the query refer to itself, or is it called twice in the
button Click event, or does it refer to another query that prompts for
the information?
 
Back
Top