Hi Richard. I'm running some parameter queries. I have auditors that go out to our schools and i have dates that the auditors visit. I'm running parameter queries on the auditor names and dates. Everything is fine except that i get the parameter prompts TWICE - EVERY TIME (??). In the Auditor field i have
Like [enter auditor] &"*"
and in the AuditDate field i have
Between[enter start date] And [enter end date]
Is it some sort of glitch in my system that gives me each prompt twice or is there something wrong with my code?
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Microsoft Access 104.