Queries by table data

[beginner]

Hi all,



I am new to the world of Access and I'm trying to work my way through it. I am stuck on, honestly, quite a number of things and hoping someone could help me out. All I have saved in the file is table data (about a hotel, dates, type of room, etc) and I am trying to create queries that determine average length of stay based on room type, average number of visitors per room type, base income per room, strongest customer base, etc. 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. Any suggestions?????

[aytee111]

Everything depends on your table structure, so hope you have that right.

Start at the beginning and write down what you need - do the analysis of the problem before diving in:
1) room type, number of days for each visit (DateDiff)
2) total number of visits per room type
3) sum the number of days by room type
4) get the average

Once you know what you want to accomplish you can begin to create queries in their simplest form, then you can work your way down to the final result.

[unknown]

Hi,

I am working on this same question for my assignment and I am so lost.

my question is would I have to make 4 different type of queries or combined in one querie?


please help!!!!

[orange]

Here is a free data model that may help with tables and relationships. Some of the model may be outside the scope of your issue and not needed.