By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,587 Members | 1,070 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,587 IT Pros & Developers. It's quick & easy.

Fields from two Tables on Report.

100+
P: 101
Hi,
My project is in MS Access 2002.
In that I have one Form which enter data in two different Tables, when I click on Submit Button it will run two diffrent queries one by one.
Now I want to generate Report from that Tables.
But I don't know how can I put Fields from two different Tables in Report's Detail Section.
If Feilds are from only one Table than I can set Report's Record Source property to that TableName.\
But I don't know how to set it for two tables?

Even I put fields in Report and set there Control Source Property to that [TableName].[FieldName]. But when I open report It will ask for the value of that TableName

like some of my Field's Control Source Properties are
=QCDatasheetForBottlesCTC!BODet
=QCDatasheetForBottlesCTC!TargetBO
=QCDatasheetForBottlesCTC!CapTorqueChartTime

but when I open Report it will ask for value of QCDatasheetForBottlesCTC.
I don't know what to enter in it.I tried the TableName but nothing happen.Report only shows values from Table which is set as Report's Record Source Property.
And whatever remain Fields from another Table in that it shows #ERROR.
Plz tell me how to do this thing?
Thanks.
Jan 31 '08 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
You can use subreports for the two queries.
Feb 5 '08 #2

Post your reply

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