Complex query question

[ausmoran]

I am attempting to create a query that will produce four columns of data for four different time periods. Perhaps it is best if I give an example:
I have a flat data file with the following fields
ID Number
Price
Date
County
I would like to create a dataset broken down by county in which I show a count for the number of occurences of a specific county within several date ranges, as follows

County - CountRange1 - CountRange2 - CountRange3

I would also like to ask the user to enter the date ranges for each column at run time.

Any help you can provide would be greatly appreciated.

Thanks in advance!
Austin