Query help pllllease???

[yoti29]

Hi,

I am new to access and DB in general and I am trying to construct a DB for my small business. I have a problem which I am sure someone can help me with.

I am trying to create a Query that does calculations on records which involve IF statements. I think I tried every possible syntax for the statement using the expression builder but it doesnt seem to accept it.
I have a field "totalSum" and I want the query to calculate 20% of it IF its below 300 and 21% IF its Higher.

Any help will be appriciated.
Thanks.

 

[danielc]

Hi,

You can try: IIf([totalSum] < 300; [totalSum]*0.2; [totalSum]*0.21)

Hi,

I am new to access and DB in general and I am trying to construct a DB for my small business. I have a problem which I am sure someone can help me with.

I am trying to create a Query that does calculations on records which involve IF statements. I think I tried every possible syntax for the statement using the expression builder but it doesnt seem to accept it.
I have a field "totalSum" and I want the query to calculate 20% of it IF its below 300 and 21% IF its Higher.

Any help will be appriciated.
Thanks.

 

[yoti29]

Thanks

It works. THANK U VERY MUCH