Count on ID

[dssrun]

I have a large table with Month and Identification. I need to create a query that shows only Identification numbers that are in every since month (i have 4 months loaded). E.g. ID number 5 is in jan, feb, mar, apr. and ID number 6 is in jan, feb, mar, but only 5 would be returned in the query and the count (so if it occurred 10 times over those 4 months the query would ready ID 5 | COUNT 10). There are about 150000 records since the month and ID have very detailed fields in their records. The primary key is an AutoNumber field. Something like this may work, but I am stumped?

SELECT ID, MONTH, [Whatever else]
FROM IdsAll
WHERE ....

Or do i create a table for each month and setup a query that way? Thanks in advanced.

[rpeare]

Can you give an example of what your data looks like in the table and what you want it to look like in your query because I'm a little confused by your descriptions.

[dssrun]

This is the table

AutoNumber | Report Month | ID | Location | Revenue | Discounts | Entry No. | Date Received | Name | Acct No | .... the many more fields are currency fields

This would be the query

SELECT ID, Count(ID) as CountofID, Name, ...whatever else
FROM tblIdAll INNER JOIN tblId ON tblIdAll.[Ids] = tblId.[Ids]
WHERE ... (get only IDs in all months);

[rpeare]

Ok that's your table structure, but what does your data look like and what do you want it to look like?

[dssrun]

I was able to create a solution. Sorry for being unclear but I was unable to share the data, so it was hard to explain what I was working with. This is what I did:

'Create a subquery that does a count distinct with ID and month. 
'The total sum per ID should be 1,2,3 or 4 depending on its unique occurrence
in either of the four months. This will tell me if an ID is in all four months at least once 
(so i put a condition in this subquery for 4).
This acts as the "primary key query" for the master table to get 
only those IDs 'and all the detail i need with it

SELECT P.[ID], tblMaster.[Detail Field here], tblMaster.[Detail Field here], tblMaster.Detail Field here, tblMaster.Detail Field here
FROM (SELECT Count(*) AS N, T.[ID]
FROM (SELECT DISTINCT [Month], [ID] FROM tblMaster)  AS T
GROUP BY T.[Patient Number]
HAVING (((Count(*))=4))
)  AS P INNER JOIN tblMaster ON P.[ID] = tblMaster.[ID]