Show weeks a record has met query criteria

[Iragalam]

I have a query that outputs certain records when they meet the given
criteria. What I am looking for is a way to output the number of weeks a
specific record shows up in the query. Today everything should show 1 week
--> Next week the records that remain from last week should say 2 while new
records will say 1.

I am stuck on this so any suggestions / help would be great. Thanks!
-Paul

 

[John W. Vinson]

I have a query that outputs certain records when they meet the given
criteria. What I am looking for is a way to output the number of weeks a
specific record shows up in the query. Today everything should show 1 week
--> Next week the records that remain from last week should say 2 while new
records will say 1.

I am stuck on this so any suggestions / help would be great. Thanks!
-Paul

Any answer would require knowing at least something about the query. All I can
suggest right now is that you could use DatePart("ww", [datefield]) as a
grouping field in a totals query. Perhaps you could post the current SQL of
the query?