Making Name Tags

[Eric Starn]

I am tasked in making Name Tags(Labels) from the Names from my database. I
have created a query of the just the [First Name] and [Last Name] of all
needed employee names. I am not quite sure where to go from here, so an
guidance will be appreciated.

Eric

 

[Lars Brownies]

In Access2003 you have a reportwizard which includes a wizard to create
address labels (make sure the reports 'tab' is visible and click 'New'.
Maybe you can start there and use your query.

Lars

 

[Al Campagna]

Eric,
In your query behind the labels (aka name tags) report, concatenate the
[First Name] and [Last Name] in a calculated field...
(using the query design grid...)
FullName : [First Name] & " " & [Last Name]
Now, place the bound field FullName on your name tag report.

Tip: If you don't use spaces in your field anmes, you can drop the
bracketing...
FullName : FirstName & " " & LastName
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Eric Starn]

Ok,
First of all I am using Access 2000. I don't know if this will make a
difference.

Second, Right now I just have the query. So you are saying add a calculated
field to the query to combine the first and last name, then make a report on
that field.

Sorry to be a pain
This is a new one for me.

Thanks

Eric

Eric,
In your query behind the labels (aka name tags) report, concatenate the
[First Name] and [Last Name] in a calculated field...
(using the query design grid...)
FullName : [First Name] & " " & [Last Name]
Now, place the bound field FullName on your name tag report.

Tip: If you don't use spaces in your field anmes, you can drop the
bracketing...
FullName : FirstName & " " & LastName
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

I am tasked in making Name Tags(Labels) from the Names from my database. I
have created a query of the just the [First Name] and [Last Name] of all
needed employee names. I am not quite sure where to go from here, so an
guidance will be appreciated.

Eric

.

 

[Al Campagna]

Eric,
The version makes no difference. Creating a calculated "bound"
field in a report query is a very common task in all versions of Access.
Your going to take the query you're building, and make it the
Record Source of your Name Tag report.
Using the query design grid, go to a blank column in your query,
and in the Field row of that column... enter this...

FullName : [First Name] & " " & [Last Name]

Choose a Sort value in that column... if needed.

You've just created a "bound" calculated field named FullName.
When you place [FullName] or FullName on your report, just like
any other bound field, it will display it's values as...
Richard Jones
or
Henry Smith
..... etc...
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

Ok,
First of all I am using Access 2000. I don't know if this will make a
difference.

Second, Right now I just have the query. So you are saying add a
calculated
field to the query to combine the first and last name, then make a report
on
that field.

Sorry to be a pain
This is a new one for me.

Thanks

Eric

Eric,
In your query behind the labels (aka name tags) report, concatenate
the
[First Name] and [Last Name] in a calculated field...
(using the query design grid...)
FullName : [First Name] & " " & [Last Name]
Now, place the bound field FullName on your name tag report.

Tip: If you don't use spaces in your field anmes, you can drop the
bracketing...
FullName : FirstName & " " & LastName
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your
life."

I am tasked in making Name Tags(Labels) from the Names from my database.
I
have created a query of the just the [First Name] and [Last Name] of
all
needed employee names. I am not quite sure where to go from here, so an
guidance will be appreciated.

Eric

.