mtrueblood
Technical User
- Mar 29, 2009
- 1
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 select "BackCost" from tbl_services and "TicketQty" from tbl_ticket, I get the following error:
"The wizard is unable to open your query in Datasheet view, possibly because another user has a source table open in exclusive mode. Your query will be opened in Design View."
The database is on my local machine, and the database is not open by another user. I have read through some posts and checked for that error already. I was able to figure out how to do a calculation within 1 table, but now need to do a couple more calculations across a couple different tables. I sort of understand the basics of Access at this point.
Your help is greatly appreciated!
Thanks,
Matt
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 select "BackCost" from tbl_services and "TicketQty" from tbl_ticket, I get the following error:
"The wizard is unable to open your query in Datasheet view, possibly because another user has a source table open in exclusive mode. Your query will be opened in Design View."
The database is on my local machine, and the database is not open by another user. I have read through some posts and checked for that error already. I was able to figure out how to do a calculation within 1 table, but now need to do a couple more calculations across a couple different tables. I sort of understand the basics of Access at this point.
Your help is greatly appreciated!
Thanks,
Matt
