Simple Query Wizard - Getting Error

[mtrueblood33]

Ok. I have filled in a few records so far. I will shoot it back in a second. Thanks and sorry about that.

Thanks,
Matt

 

[mtrueblood33]

This should do it.

 

[mtrueblood33]

It is a fairly simple database / web application. The user has the ability to design their own raffle/addmission ticket. First they choose the color they want, then they select the quantity from a drop down menu. From there they choose services such stapling, padding, uploading an image, printing on the back, and shipping.

- Stapling is $0.06 times the selection (StaplingChoice).
- Padding is $0.10 times the selection (PaddingChoice).
- Artwork is $10.
- Back is $15 times how many 1,000 tickets (TicketQty from tbl_ticket)
* This is where I am hung up as the calculation needs to tie in TicketQty from tbl_ticket.

After they choose their services, they enter in their shipping and credit card info and submit the order.

If you need more, please let me know.

Thanks,
Matt

 

[John Big Booty]

Have a look at Query1. It's doing what you want ie. (TicketQty/1000)*15

Now if you want that stored in your services table (and there are many reasons why you shouldn't) you will need to change that select query to an update query, See Query2.

 

[mtrueblood33]

Did you post it back? I am not seeing the file.

 

[John Big Booty]

My bad forgot to press the button, sorry.

 

[mtrueblood33]

I appreciate your help. I am going to look over your query in more detail tomorrow. I understand what you mean by not storing the info in the table, just in the query. I'll look into that a bit more as well.

Thanks again for your help! It's greatly appreciated.

- Matt

 

[John Big Booty]

No worries, glad to have helped

 

[mtrueblood33]

John,

The Query works like a charm. Thank you.

Now. I need to know what you did as I have two more calculations to do. I need to total up all the services now (cost of services = staplingcost + paddingcost + artworkcost + backcost). Then I need to total up the cost of the services + the ticket cost; to get a final order cost.

I tried to understand and duplicate what you did for "back_cost", but it isn't working properly. Hope this reaches you soon!

 

[John Big Booty]

How are these other cost being calculated?

 

[wiklendt]

whoa - looks like you've got some SERIOUS normalisation issues!