Wildcard

T

tvh

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
 
T

tvh

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...
 
Top