Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 262
  • Last Modified:

MS Access QBE Syntax Issue

My query is this...

SELECT
.
.
.
HAVING (((THDWH1_MYTRANS.SOURCEKEY)='%' & [Enter Order Number]));

This prompts the user to enter criteria.  I would like to have a wildcard before their entry, however, I can not determine how to string both together (I attempted the '&' to tie the wildcard to the [enter order number]).
0
Derek_Indianapolis
Asked:
Derek_Indianapolis
  • 2
1 Solution
 
mbizupCommented:
HAVING (((THDWH1_MYTRANS.SOURCEKEY) LIKE '*' & [Enter Order Number]));

Use LIKE instead of =
* is the all-inclusive wildcard in Access.
0
 
Derek_IndianapolisAuthor Commented:
Thanks
0
 
mbizupCommented:
Glad to help!
0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now