Listing first and last name in reports

[Guest]

I have a Query that finds the first and lastname that is stored in separate
fields in a table.

In a report I would like to join them toghether, so it looks like this:
lastname, firstname

I have seen a suggestion using: select lastname & ", " & firstname from
tbl:table

But I am not able to find out how to use this information. It looks good but
I do not know where to put it in.

Can anybody help ?

 

[Guest]

In design view add an output field to the grid like this --
Name: [lastname] & ", " & [firstname]

 

[Guest]

Thanks, that worked.

Petterq

When You write "Name:" Should that be used in a spesific way, or

In design view add an output field to the grid like this --
Name: [lastname] & ", " & [firstname]

I have a Query that finds the first and lastname that is stored in separate
fields in a table.

In a report I would like to join them toghether, so it looks like this:
lastname, firstname

I have seen a suggestion using: select lastname & ", " & firstname from
tbl:table

But I am not able to find out how to use this information. It looks good but
I do not know where to put it in.

Can anybody help ?

 

[Guest]

No, you can just as easily use X for the output field label.

Thanks, that worked.

Petterq

When You write "Name:" Should that be used in a spesific way, or

In design view add an output field to the grid like this --
Name: [lastname] & ", " & [firstname]

I have a Query that finds the first and lastname that is stored in separate
fields in a table.

In a report I would like to join them toghether, so it looks like this:
lastname, firstname

I have seen a suggestion using: select lastname & ", " & firstname from
tbl:table

But I am not able to find out how to use this information. It looks good but
I do not know where to put it in.

Can anybody help ?

 

[BruceM]

FWIW, I would tend not to use Name or other reserved words in such a
situation. I would tend toward something such as LastFirst or FullName.

No, you can just as easily use X for the output field label.

Thanks, that worked.

Petterq

When You write "Name:" Should that be used in a spesific way, or

In design view add an output field to the grid like this --
Name: [lastname] & ", " & [firstname]

:

I have a Query that finds the first and lastname that is stored in
separate
fields in a table.

In a report I would like to join them toghether, so it looks like
this:
lastname, firstname

I have seen a suggestion using: select lastname & ", " & firstname
from
tbl:table

But I am not able to find out how to use this information. It looks
good but
I do not know where to put it in.

Can anybody help ?