Fields from two Tables on Report.

[billy_pit]

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.

 

[Carl Rapson]

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.

You need to create a query that joins the two tables. Then, use that query
as the RecordSource of the report.

Carl Rapson

 

[billy_pit]

Ya but I want to select all fields from one table and some fields from
another table so how can i do that?

 

[billy_pit]

Another thing in my report i have 258 fields so when i open my report
it will show error msg that too mane feilds define.
so what to do?i don't know how to add fields more than 255.

 

[Duane Hookom]

What you should do about this is "not ask the same question in two separate
threads". There is at least one reply in a more recent thread.

 

[Carl Rapson]

Ya but I want to select all fields from one table and some fields from
another table so how can i do that?

In a query, when you join two tables you can select any or all fields from
each joined table. Use the Query Wizard to create your query and you'll see
how it works.

Carl Rapson