Subreport link by Date field

D

Don

Hello, I have an Access 2003 report with a subreport. The main report has a
column for customerID and Date, I want the subreport to show any records from
another table that occurs after the Date on the main record. Can I use the
Link Child Field and Link Master Field for this? I know I can put
"CustomerID;Date" in these fields but that would give me results that have an
exact date match.

Thanks
 
K

KARL DEWEY

Try using CustomerID in the links and Date criteria from main form in query
for the sub.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show subreport conditionally 2
ordering by date in a subreport 1
SubReport Problems 1
Report w/subreport; Subreport not displaying related records 4
how can i propogate a subreport filter up to the main report? 7
Subreport Linking 3
Report filter problem 1
Need assistance with Subreport multiple columns 12

Top