Need Help with simple query-- Adding two fields together

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

I'm doing coursework, racking my brain. I can't simply
add two fields together.. I created a new field named
BillTotal and wanted this field to add two other fields
together within this query named "OrderAmt"
and "DeliveryCharge".

I did this by putting in the Field text box "BillTotal:
[OrderAmt] +[DeliveryCharge}. This doesn't seem to work,
please help.

BTW, OrderAmt and Delivery Charge are in two seperate
tables which are already in the actual query.
 
Ok, I figured this one out on my own by hitting the
stupid "Totals" button.


But now I have to do a IIf function to add an additional
two dollars to the BillTotal if the City field
= "Naples". I know how to do this by adding another field
but this displays the information in a different field or
total from BillTotal. How would I go about making it only
show the whole total in BillTotal?

I tried doing the following in the BillTotal, but it
doesn't seem to work;

IIf(City="Naples",Sum([OrderAmt]+[DeliveryCharge])+2,Sum
([OrderAmt]+[DeliveryCharge])

What am I doing wrong?
 
Back
Top