Query within a query?! And its snowing!!!!

[Dineedshelp]

Stuck at present and want to go home!!!

I have create a query which pulls out specific records that I want (wahey, got that bit right!!!). The next step to this is to somehow group the records based on todays date. For example, todays date is the 4 feb, i want to see the records that were input for the last 14 days together, then 15 to 30 days and then anything greater than 30.(To get the number of days I've used a datediff based on the input date and todays date).
Is there a way of doing this? I've tried a cross-tab query, but that does it by month and not specific dates.

Please help or i may be forced to go sledging!!!

Thanks

 

[MichaelRed]

? sledging ? does this relate to the 'snow' or the 'job'?

but on to the other aspects ...

did you just want all of the (three) subsets of the records in a single resultsset (perhaps denoted as to their group)? of three seperate resultssets?

MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[Dineedshelp]

Sledging.......going fast down a hill on a piece of plastic with no control what so ever.........insane really!!

Anyway, totally in over my head here, but probably three separate results would be better, provided they were within the one query, but then again, knowing my luck everything will change again and i won't need any of it!!!!

PLEASE tell me you can help!!!!

Thanks