Wildcard

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

Guest

I would like a query to show my current Work Order #, plus all related work
orders with one or more letters behind it (i.e., W-193, W-193A, W-193BC,
etc.). I've used the formulas

[Forms]![frmWorkOrder]![tblwoWorkOrder#] Or Like "#"
[Forms]![frmWorkOrder]![tblwoWorkOrder#] Or Like "?"
[Forms]![frmWorkOrder]![tblwoWorkOrder#] Or Like "*"

which don't quite work. Any suggestions?

Thanks
 
Damn! I knew it was something simple like that. Thanks Rick...works perfect!

Rick B said:
Like [Forms]![frmWorkOrder]![tblwoWorkOrder#] & "*"

--
Rick B



tvh said:
I would like a query to show my current Work Order #, plus all related work
orders with one or more letters behind it (i.e., W-193, W-193A, W-193BC,
etc.). I've used the formulas

[Forms]![frmWorkOrder]![tblwoWorkOrder#] Or Like "#"
[Forms]![frmWorkOrder]![tblwoWorkOrder#] Or Like "?"
[Forms]![frmWorkOrder]![tblwoWorkOrder#] Or Like "*"

which don't quite work. Any suggestions?

Thanks
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add 1 to Work Order # 2
Reset Combo Box when fields do not contain data 0
update table with form and subform 3
ACC2K3: Multi-table Update Transactions Are Unreliable 11
text to column in Access 4
Wildcard in query 10
How assume wildcards in a query criteria 3
Launching a Form from Within a Form to Create a New Record 1

Back
Top