create a seperate report for each record

[thor10]

I am linking Access 2000 to a SQL view. The view contains the criteria to narrow the records down. What I would like to do is create a report for each individual that meets criteria then emails each individual report to that user. Moe, Larry and Curly might have a report today, but tomorrow, it may only be Curly. Is something like this possible? I'm sure that this is as clear as mud.

Thanks for your time and help in advance, it is greatly appreciated !

 

[Abulafia]

How are you determining who gets a report?

 

[thor10]

I am looking at 2 different fields,
(field1 IS NULL)
AND
DATEPART(YEAR,datefield1) = (DATEPART(YEAR,GETDATE()))