Joining Rows

[Greg B]

Hi all I am very inexperienced at Access and I am wondering on how to
connect names. In one table I have the surname and first name and on
another table I wish to combine them so the report shows

i.e.

Brow, G.

The name of the original table is individual, the rows are fname and sname.

Thanks

Greg Brow

 

[J. Goddard]

Hi -

You don't need to put them another table in combined form. You can
combine them in a query field (along with all the other data you need
for the report), base the report on the query, and then use the field in
the report.

Fullname:[individual].[sname] & ", " & [individual].[fname]

would be the expression for the query field, and the report control
would have [fullname] as its control source.

P.S. : I assume by "Rows" you are referring to table fields?

John

 

[Greg B]

Thanks for that,
Greg

Hi -

You don't need to put them another table in combined form. You can
combine them in a query field (along with all the other data you need for
the report), base the report on the query, and then use the field in the
report.

Fullname:[individual].[sname] & ", " & [individual].[fname]

would be the expression for the query field, and the report control would
have [fullname] as its control source.

P.S. : I assume by "Rows" you are referring to table fields?

John

Hi all I am very inexperienced at Access and I am wondering on how to
connect names. In one table I have the surname and first name and on
another table I wish to combine them so the report shows

i.e.

Brow, G.

The name of the original table is individual, the rows are fname and
sname.

Thanks

Greg Brow