A ajarrell Registered User. Local time Today, 01:45 Joined Feb 4, 2014 Messages 56 Mar 16, 2014 #1 Is it possible to add a query to an existing report? I use Access, not VBA. Thanks.
P plog Banishment Pending Local time Today, 00:45 Joined May 11, 2011 Messages 12,031 Mar 16, 2014 #2 To your exact question, no; but to your intent, yes. Reports can have at most 1 query as their Record Source. However, Reports can have sub reports embedded into them which are based on different queries. Check out this link for sub reports: http://office.microsoft.com/en-us/access-help/create-and-use-subreports-HA010209281.aspx
To your exact question, no; but to your intent, yes. Reports can have at most 1 query as their Record Source. However, Reports can have sub reports embedded into them which are based on different queries. Check out this link for sub reports: http://office.microsoft.com/en-us/access-help/create-and-use-subreports-HA010209281.aspx