query results

[motov600]

quick help really stuck here

hello

on my database im tring to create a query where is looks at the first 2 characters in the field and if its first 2 characters are OF then the first 2 characters of offers which are BR and PF will also be shown.

something like

IIf(Left[Order_No]="OF" then show "OF","BR","PF" in results

if i want OF then it also shows BR and PF with it in the report or query

hope someone can help

thanks

 

[BryanT]

Hello motov600

Try
IIf(Left[Order_No],2)Like"OF"


Bryan

 

[neileg]

Create a calculated field
NewField: Left([Order_No],2)
Add a criterion to this field "OF"