IF Statement with Access.

[zan03]

Hi, The question I have is how to use an IF Statement with Access.
a. Using access I created a table made of 7 columns

1. ID_Number
2. Building_ID
3. Unit_ID
4. Floor_ID
5. WorkItem_ID
6. Quantity
7. Total_Price

From this table, I created a form and added these additional fields.
1. Square feet
2. Linear Feet
3. Quantity

I need to create a Query to calculate this additional field
1. Total Price

For certain work items, you need to multiple one item cost by the square feet and ADD it to the linear feet x another item cost to get the total price for that item.

I have 70 work items, but will only need to run a calculation on about 10 of them…

I do not have a “sq ft” or “ln ft” column in my table, but I created a box for both items in my form… is that the best route?

I’m open to any suggestions as I’m completely lost…

Thanks,

Zanna

 

[SkipVought]

Check out the IIF() function.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]