Linking problem - Subreport

[elaineva]

I have 4 reports from different tables that I want to merge into one report using 3 subreports. I link 3 subreports to the master report using either cont # or vendor # - works great – no problem.

The problem comes in when I want to add a date pulldown “>=[date_field]” The master report pulls the correct data – but of course – the 3 subreport do not because I can’t link date to date field as some dates may be greater than dates in the master report.

I’m sure the answer to my problem is very simple – but I’m sure missing it – please help.

 

[dhookom]

You must base your subreports on queries that use the >=[Date_field].

Duane
MS Access MVP
Find out how to get great answers faq219-2884.