Combine First and Last name fields for Report

[yes sir]

read this:

https://www.accessforums.net/faq.php...b3_attachments

you may have an unaccepted type or it might be too big. forums always accepts ZIPs. you can always zip it. also, compact it before you upload. it may be bloated if you haven't done this

If I get this to work, could we switch over to Yahoo! chat or AOL Aim?

Thanks

[ajetrumpet]

I will be working on something else here at my house, but my messaging options are next to my name. I have yahoo and aim.

BTW, I loved the taskbar on top like you have on your machine. Did you know you can rotate your screen 90 degrees by ctrl+alt+arrowkey??

I found that by accident last week. It works on xp and vista, but apparently not on 64 bit machines? my DT is 64. weird! I was looking forward to reading upside down tonight.

[yes sir]

Alright, after trying everything. I zipped her up for you.

[ajetrumpet]

send me a message if that's what you want to change to

[yes sir]

I will be working on something else here at my house, but my messaging options are next to my name. I have yahoo and aim.

BTW, I loved the taskbar on top like you have on your machine. Did you know you can rotate your screen 90 degrees by ctrl+alt+arrowkey??

I found that by accident last week. It works on xp and vista, but apparently not on 64 bit machines? my DT is 64. weird! I was looking forward to reading upside down tonight.

LOL. I didn't know that about rotating your screen. I'm going to mess with that later.

I threw the taskbar on top and have liked it ever since. But the real reason I did it was because I tossed a screwdriver across my room one day and it nailed my screen and left a small dent (lucky me) on the bottom where the taskbar originally was. Now the dent is in a spot where I hardly look.

[yes sir]

send me a message if that's what you want to change to

I added you on yahoo, but I have never used their IM services. I added something on AIM, but it shows you as offline.

[ajetrumpet]

is this what you want?

[yes sir]

Yes it is. I'll also want that for the Agent as well (currently shown as N/A and N/A). Is that possible? And yes you are a genius.

[ajetrumpet]

Yes it is. I'll also want that for the Agent as well (currently shown as N/A and N/A). Is that possible? And yes you are a genius.

A GENIUS. LAUGH.

put this in the tbox control source:

=[first name] & " " & [last name]

do the same for the agent box. I'm sure you can do that yourself now.

[yes sir]

A GENIUS. LAUGH.

put this in the tbox control source:

=[first name] & " " & [last name]

do the same for the agent box. I'm sure you can do that yourself now.

I did this earlier, but with capital letters. Would that matter? Maybe I did something else.

Also, wouldn't the code need to be adjusted for the Agent? Its not as simple as adding another text box and typing in the same control source, it would just put ### again.

[ajetrumpet]

character case is irrelevant in most parts of access (for all practical purposes, unless you are at expert level doing coding).

if you notice on your rpt, the agent fields are called LAST NAME_AGENTS (etc...). You changed them using the AS keyword in the query.

[yes sir]

if you notice on your rpt, the agent fields are called LAST NAME_AGENTS (etc...). You changed them using the AS keyword in the query.

True, so how do I go about combining the first and last names for the Agents on this same report?

[yes sir]

True, so how do I go about combining the first and last names for the Agents on this same report?

I used the same control source as you, but subbed First Name_Agent instead of first name and did the same for the last name, but now I'm back to getting the parameter value message box upon opening the report.

[ajetrumpet]

True, so how do I go about combining the first and last names for the Agents on this same report?

i think your brain is getting a little fried. this is simple sir:

=[FIRST NAME_AGENTS] & " " [LAST NAME_AGENTS]

catching on?

[ajetrumpet]

I used the same control source as you, but subbed First Name_Agent instead of first name and did the same for the last name, but now I'm back to getting the parameter value message box upon opening the report.

hang on then.