Criteria Prompt in Access Data Project

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

Guest

I just upsized to a Data Project and my user prompts aren't working.
What's the correct syntax for SQL?
Thanks
 
okschlaps said:
I just upsized to a Data Project and my user prompts aren't working.
What's the correct syntax for SQL?
Click to expand...

Without much detail, a WAG might be
that your SQL is still using "*" wildcard,
which you need to change to "%"
 
Hi okschlaps,

Use a stored procedure.

Views (equivalent to "queries" in Access)
do not support the "bracketed user input"
syntax (to my knowledge).

good luck,

gary

okschlaps said:
No, no wild cards. Just a simple [Enter Invoice Number].
Thanks

Gary Walter said:
Without much detail, a WAG might be
that your SQL is still using "*" wildcard,
which you need to change to "%"
Click to expand...
Click to expand...
 
Ahh, that explains it. Good to know. Thanks.

Gary Walter said:
Hi okschlaps,

Use a stored procedure.

Views (equivalent to "queries" in Access)
do not support the "bracketed user input"
syntax (to my knowledge).

good luck,

gary

okschlaps said:
No, no wild cards. Just a simple [Enter Invoice Number].
Thanks

Gary Walter said:
:
I just upsized to a Data Project and my user prompts aren't working.
What's the correct syntax for SQL?

Without much detail, a WAG might be
that your SQL is still using "*" wildcard,
which you need to change to "%"
Click to expand...
Click to expand...
Click to expand...
 
Back
Top