Recent content by Shauqeen

Thanks It works

whereas my yes or no field name is [discount] and my gross amount field is [Amount] and my calculation in another field (I don't know how to write an expression) What I am trying to do is to calculate only selected customer from my yes or no field. what I did was iif([discount] than[amount]*.0625.

I created a yes and no field in my sales table, and create a calculated field in a query, now when I run a query it still calculates non discount customers

like yes/no field and if yes then how do I tell calculated field to select those customer

The table name is sales filed names are Name, amount now how can I create a query in which I can select some customer with a discount and some with no discount and calculate their total accordingly

in my query field 1 is from a table and field 2 is Field 2:[field1]*.623 now I want to select some record from field 1 to be calculated in field 2 and some not. how do I achieve this

Can someone help me on my issue? I have four fields in a query Two fields are calculated and two fields are name and amount I want one field to calculate only selected names on the name field. any Ideas

Does not work. I am new to this If you please show me how to write criteria in a query which has several queries in it. when we run query some has data and some don't. one which does not have any data available for required date it shows me blank and I could not use blank field in form or report

I could not find the help any one knows how to write criteria to get zero if there is no result in the query.

I there is no result in query, I need the default result zero in my form field. I only use query wizard to create queries