Architects room data sheets
Within my room information input form I have the room number and name at the top and have tabbed pages for each section of the room data sheets, piped services, wastes, power and comms.etc.I haven't had any problems setting these up so far and all seem to work fine.
I now need to add the relevant equipment which will be within each room. I have created a separate table for each piece of equipment with the relevant information eg name, manufacturer, size, required services.etc.
I would like a tabbed page within my room information input form which produces a drop down list where I can select a piece of equipment (from my equipment table) and type in the quantity of that piece of equipment within the room, once I have selected a piece of equipment I want it to produce a second drop down list where I could add a secondor third if required.
Currently when I insert the table it does just that and gives me a list of all the items within my equipment table. This tells me I should not be importing the table but I'm not sure what ineed to produce (table, query,form)
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I want a button to create a report for the estate at hand. This report will show the items in the estate, grouped by room. I have the report showing what I want, but the problem is that it is reporting on all estates - not just the active one.
How can I do this? I am trying to keep this as user friendly (least amount of typing/ideally just a single button) as possible.
Customer: (Customer ID, Last Name, First Name, Contact Number, Email) Key: Customer ID
Room: (Room ID, Room Name, Phone Number, Equipment, Disabled Access, Capacity) Key: Room ID
Booking: (Room ID, Customer ID, Subject, Booking Date, Time) Key:Room ID & Customer ID
The customer needs to be able to book the same room in the same day at a different time but this is leading to the Room ID being duplicated and this is the primary key.
For this scenario we need to define the following facts:
These facts define the requirements which the Database must meet and should be agreed between the Database User and the Database Designer prior to physical creation.
A local hotel needs a system that keeps track of its bookings (future, current and archived), rooms and guests. A room can be of a particular type and a particular price band. Room prices vary from a room to a room (depending on its type, available facilities, band, etc.) and from a season to a season (depending on the time of the year).
I am pretty familiar with excel and what I would have done was determine the # of days based on the arrival/departure date and then run an averageif function for each room type. I don't know what to do with access though
I am completely stuck on how to run a query for the first request (average length of stay based on room type.
I am pretty familiar with excel and what I would have done was determine the # of days based on the arrival/departure date and then run an averageif function for each room type. I don't know what to do with access though.
1. The average length of stay per room type
2. The average # of visitors per room type
3. The base income per room length of visit x daily rate) during a specified period of time (a single month)
I have the following fields:
I have been able to do a query including the room type, arrival and departure dates.
I have been doing a bunch of online learning for access but it is not helping. Maybe I am taking the wrong online courses. Can anyone help me to understand how to make calculations and where they are placed in a query
Each form can grow or shrink and maybe even not be visible (no students in room 56). Size and presence of the subform could be detected and subforms placed and positioned.
Reports have an excellent solution to this with a group by option. No option exists for forms.
I have a two tables
---------------------(holds room details)
from this I like get the reservation detail mostly notreserved details
like: if a room reserved
2007/06/05 12:00 to 2007/06/07 13:00
this room shuold not apear in the serch query results (if I serched for free roms
between 2007/06/05/ any time to 2007/06/06 any time
I have another table with records that contain a room property as well as the light fixture key. So for example, a series of records could be:
E01 - living room
E02 - living room
E01 - dining room
E03 - kitchen
E01 - kitchen
The tables are linked and I want to create a report that shows all the light fixture data, including a list of all the rooms in which that fixture is used.
E01 - living room, dining room, kitchen
E02 - dining room
E03 - kitchen
I created a crosstab query that shows the quantity of each light fixture in each room, but I can't figure out how to use that to get what I want.
Ideally, all I want is a string to use in a report, but I'm not sure how to get it.
I think I've just gotten too bogged down in the problem.