Generate report from multiple date queries

[wbow]

Have an Access 2003 database with three tables; tbMgr, tbEng and tbQuals.

EngID is the primary key field in the tbEng table which is imported into the tbQuals table on a one to many relationship, with tbMgr having a one to many relationship with tbEng.

Each EngID has up to 30 Quals each with its own expiry date.
I need to generate a report for each EngID showing only those Quals that have expired, or are within 30 days of exipry for e-mailing to their mgr.

Could anyone please explain how to do this?

Thank you

 

[SkipVought]

Hi,

Try posting the forum703.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[wbow]

My Apologies, posted in forum 703: Microsoft: Access Reports as suggested.

Thank you.

 

[SBTBILL]

The way I usually do this is to create a temporary table and then use a loop to populate it from the permanent tables. I usually use VFP however. I think Access and VB could be used the same way.

I'm assuming that a joined quiry produces duplicate records. Otherwise I'd just do a join.