Joining Rows

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Greg B - 05 Oct 2006 02:56 GMT

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

Reply to this Message

J. Goddard - 05 Oct 2006 03:21 GMT

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
[quoted text clipped - 9 lines]
>
> Greg Brow

Reply to this Message

Greg B - 05 Oct 2006 03:50 GMT

Thanks for that,
Greg

> Hi -
>
[quoted text clipped - 26 lines]
>>
>> Greg Brow

Reply to this Message