Access Query where Count is = to N, Please Help!!!

[hip2b2]

I have a single table with Stock Ticker Symbol, Numeric Value, Date. I need to build a query that will output ONLY the tickers that are represented in each month of the data sample, i.e., where date is = 29 (months).

Easy to do in Excel, but database is 150,000 records and so I'm committed to Access.


Thanks in advance.

ray:

 

[bat17]

You can filter on date as your criteria to get records from a range. in the criteria of your date field >#01/01/2002# And <#01/01/2003# would give you a years data.
If this is not what you are after please post back with more details.

Peter

 

[hip2b2]

Will this provide me with all records that ALL the dates between the range?

Thanks

hip ray:

 

[SydneyGeek]

Yes, but it will hard-wire the query / table. This post...
http://www.mrexcel.com/board2/viewtopic.php?t=64473
...gives a more general and user-friendly way to set it up.

Denis

 

[hip2b2]

What seems to be happening is that any record between the date range is returned. I am looking for a statement that will only return the records where ALL the date conditions are satisfied.

Thanks again

hip

 

[SydneyGeek]

Just to clarify...
If you have stock ABC, you ONLY want to see it if, in a range of 30 months, its ticker appears 30 times? Any less, forget it?

Denis

 

[hip2b2]

Exactically, ONLY those cases that are represented every month of the date range.

Thanks

hip