Filter out data in a query

[CaliburBlade138]

Hey all,

So I got a query going for a table that has all my data in it. Under the field [myBarcode], there will either be a sales order such as 5555555/55 or text that says Indirect Labor, it could be a mix. What I would like to do when I query, is separate all the sales orders and Indirect Labor under a certain individual so that I can use them in my stacked column chart. How do I?

[Gicu]

You would add a calculated field to the query: OrderType:Iif(Instr([myBarcode],"Indirect")>0,"Indirect","Order"). Now you should have a field with "Indirect" or "Order" that you can use in your chart.

Cheers,

[CaliburBlade138]

Thanks, exactly what I was looking for!

[Gicu]