In a recent forum message, luzhen 88 wrote:
"I have a MS Access Database file. In my query, I would like to group all of the Company Names and count them. I have to create a report that will display the companies that have multiple bookings.
Example:
Company Name
ABC
ABC
ABC
RTY
RTY
YUI
QWE
QWE
QWE
I need to be able to count all of them in a query. How do I do that? I should have a table and the results should be like this:
Company Name | Bookings
ABC 3
RTY 2
YUI 1
QWE 3
But since the question asks me to display the companies that have multiple bookings, I assume that "YUI" with the result 1 would be omitted, right? How will I do all of the above in a New Query?"
Do you have any advice? Interested in answers to the same question? Visit the About Databases forum and join the discussion!
"I have a MS Access Database file. In my query, I would like to group all of the Company Names and count them. I have to create a report that will display the companies that have multiple bookings.
Example:
Company Name
ABC
ABC
ABC
RTY
RTY
YUI
QWE
QWE
QWE
I need to be able to count all of them in a query. How do I do that? I should have a table and the results should be like this:
Company Name | Bookings
ABC 3
RTY 2
YUI 1
QWE 3
But since the question asks me to display the companies that have multiple bookings, I assume that "YUI" with the result 1 would be omitted, right? How will I do all of the above in a New Query?"
Do you have any advice? Interested in answers to the same question? Visit the About Databases forum and join the discussion!
Group the query using the Epsilon icon.
Pull down the company name 2 times
The first one should be “group” and the second one should be “count”. This will give you the results you require.
Criteria for the “Count” should be >1
Good Luck.