forms and formulas (rolls eyes)

[Stewit]

I've been trying for quite a few days to beat this little problem, im trying
to design a sales tracking database.

It's a single form, I will be reporting from it at somestage, I don't have a
clue about queries I tried that and got way to complicated for me at the
time.

I've been totally successful in getting this to work in excel, but im
totally out of my depth in access...

the first calc im attempting is establishing if the sale price is =< $100 if
less I need to show a fixed amount, if more I need the dollar amount to be
calculated on a %. as shown below in the excel formula i use

=IF(I3=0,"",IF(I3<=100"$ .90",I3*50%))

im okay with the basic /*-+ in access so far lol.

i hope this is a challenge to some of the experienced users here, it's
proved more than a challenge to me!!!

thanks in advance for any help and or suggestions
Stewart

 

[Marshall Barton]

I've been trying for quite a few days to beat this little problem, im trying
to design a sales tracking database.

It's a single form, I will be reporting from it at somestage, I don't have a
clue about queries I tried that and got way to complicated for me at the
time.

I've been totally successful in getting this to work in excel, but im
totally out of my depth in access...

the first calc im attempting is establishing if the sale price is =< $100 if
less I need to show a fixed amount, if more I need the dollar amount to be
calculated on a %. as shown below in the excel formula i use

=IF(I3=0,"",IF(I3<=100"$ .90",I3*50%))

im okay with the basic /*-+ in access so far lol.

Actually, you're fairly close. The main thing is that
Access's Inline If function is IIf:

=IIf(I3=0, "", IIf(I3<=100, .90, I3 * .5))

But, depending on what you're using the for, you may have
some trouble mixing text strings and numeric values.

For a list of the functiond in Access, look in Help - Table
of Contents. There's a chapter of them.