Windows Vista multiplying 2 fields together

[icteacher]

I have a table, i want to multiply the contents of a field 'PRICE' by the value in the 'Qty' field. I want this answer in a new field called Sub total. then i want to check if this filed is below £xx.yy, if it is then add the value in a field called Delivery charge' if over £xx.yy then do not add the delivery charge. The sum of this value to be placed in a field called 'Total Due'

can it be done? thanks in advance

 

[icteacher]

Sorry this is in Access

 

[Ian]

Welcome to the forums icteacher

I don't know much about Access at all, but I did some searching and it looks like these tutorials explain what you want to do:

http://www.fontstuff.com/access/acctut02.htm

http://www.techonthenet.com/access/functions/advanced/iif.php (you'd use this to add a charge if the condition matches)

Hope that helps!

 

[icteacher]

Thanks for that, Ill try it and let you know


Peter Carter