If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Subreport link by Date field
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 |
#2
|
|||
|
|||
Subreport link by Date field
Try using CustomerID in the links and Date criteria from main form in query
for the sub. -- Build a little, test a little. "Don" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|