Search results

Great. Thanks for your input. I hope they help as I have hit a pretty decent road-block.

Sorry for the confusing thread.. As I dive more into this, I am realizing my initial question may have been a bit off. My apologies! Here's what I am having trouble with. I need to have calculated the following fields: Total = StaplingCost + PaddingCost + ArtworkCost + BackCost Total...

Hello All, I am looking for assistance on calculating values between 2 different tables, with 1 value being a query. Please let me know if you can help, thanks!

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...

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

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

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...

This should do it.

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

Sorry I deleted the records to slim down the file size. How much data do you need?

Well it's currently saved as 2002-2003 version. Do you need it in 2000? Thanks, Matt

Yes. I will save it as an earlier version and resend it.

Ok. Here is the slimmed down database. Thanks, Matt

I am going to slim it down and post it here in a second. I really appreciate your help! Thanks, Matt

The DB is 1,344 KB. Is that too big to post on here?

Actually, I think I tried that. If I know what you mean. It didn't work correctly because there wasn't a connection between the two tables (tbl_ticket [where TicketQty is] and tbl_services [where I am doing the calculation with BackCost ])

Great thanks. I will try that. Just so that I understand you completely, when you say "query design grid", where exactly do you mean? Thanks, Matt

That "$10" was supposed to be "$15". Thanks, Matt

Hello. Thanks for the response. The information is displayed. This database is used to gather info from a user on a website. The information is later displayed on the verification page before ordering. I need to be able to multiply $10 times by how many 1,000 tickets are being ordered. The...

Hello, I am trying to do a calculation between an item in 1 table and another item in another table. I want to do [BackCost = (TicketQty/1000) * 15]; where "BackCost" is in [tbl_services] and "TicketQty" is in [tbl_ticket]. Every time I launch the query wizard (Simple Query Wizard) and...