How do i calculate in a query?

[AccessXP]

I am trying to calculate a filed in a table. How orders are still out standing.

Thanks.

 

[kkapadia]

Can you explain little bit more. Contact :- k_kapadia@hotmail.com

 

[tallbarb]

Is there an item that shows whether the product is shipped, like a shipped date? You could create an expression that tests to see if that column contains data and, if it does, print nothing, if it doesn't print a message like "Outstanding". For instance:

if (Shiped_Date == null ) {"Outstanding"} else {""}

Then, if you want to see just the outstanding orders, limit the new computed column to Outstanding.

 

[tallbarb]

This is an ACCESS question? I thought it was Brio. Sorry about that. If you're using Access, one technique might be to use an immediate if (IIF) as a new field in your query grid. For instance:

Outstanding: IIF([Date Shipped]is null,"Yes","No&quot