Creating a query to count the number of times a Roomtype has been reserved

**sunstruck_d** · 12-10-2012, 08:59 AM

Hello. It has been a long time since I used Access and currently I am working my way through Your Office: Microsoft Office 2010 Volume 1 (Pearsons) for a refresher course. I am currently stuck on a question that is asking me to create a query that will count the number of times a RoomTpye has been reserved. I am successful at creating queries in this problem but I am just not creating the correct one to generate the answer that I need. What information would I need to post here so that I can get help on this problem? Thank you.

**alansidman** · 12-10-2012, 09:16 AM

Look here:

http://www.techonthenet.com/access/f...eric/count.php

Alan

Creating a query to count the number of times a Roomtype has been reserved

Thread Tools

Creating a query to count the number of times a Roomtype has been reserved

Similar Threads

Create query that copies fields X number of times from both tables?

How to COUNT number of times a record shows up in a MONTH

Count How Many times a value appears in a table

VBA: Run Query then Count number of Records then Display number on a form

Query that returns number of times an item appears alongside others in the row

Posting Permissions