469,125 Members | 1,737 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,125 developers. It's quick & easy.

How can I link two different fields in a subreport to the main report?

I am new to Access 2010 and I am trying to create a report for our daily logs. I have the main report created with two subreports, but there are two problems.

1. I need to be able to enter one date in the main report and for it to automatically pull that date's data in the sub-reports. It works, but only if I have previously searched for that date in the sub-report.

2. There is a second project field in both the main report and in the sub-reports. They are linked in relationships, but I need for the report to sort based on this data as well as the date.

For instance, if I sort by 2/14/2011, I need a report showing all the information for project x on one page and project y on the next.

Please help!

Feb 17 '11 #1
0 935

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

7 posts views Thread by Ellen Manning | last post: by
1 post views Thread by shaqattack1992-newsgroups | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.