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!
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...
I need assistance setting up 2 tables. One table "tbl_pricing" will provide data to the site, and the other table "tbl_ticket" will populate by choices from the site. I can go into more detail if need me.
Thanks!
- Matt