How do I go about setting up the equation in a query?
I attached a copy of the database. The "invoice" form is the form that i am trying to manipulate There are 2 fields in there, one is 'RoomName' and the other is 'RoomPrice' I have the room names in a drop down box. I would like to select a...
What i am trying to do i mist likely easy but i am just starting to mess around with access. When i am in my form i want to be able to select from a drop down box a room ( i know how to do the drop down box) and then once that room is selected have the price appear in another box to the side of...