Reports and making it look prettier: Last Name, First Name Rank

I'm trying to pretty up my report by eliminating the forced space created by 
having one field of the report for 'LastName', one for 'FirstName', and one 
for 'Rank.'  The Rank isn't too huge of an issue, and if three items in one 
field gets to be too much, I have no problem leaving that as a side item of 
sorts.  But, I want my report to look a bit better by putting the names 
together!  

I want the report to go to my table, pull the LastName from that column, and 
pair it with the matching FirstName in the column to the right.  (Since it's 
just looking up the personnel data, and I only have 22 personnel assigned, I 
blew off a query for this particular report...it's a nice easy one)

So I found (by the magical search box) this line of code right here in the 
MS forums:
=[FirstName] & " " & [LastName]

I tried it.  Didn't work.  And yes, the spelling is identical, and I even 
paid attention to the capitol letters, just in case.

Then I tried to go in and build the string by clicking the ... button.
=[FirstName] & [LastName] (I just want it to work, I'll worry about the 
space when I get the basics down)
Didn't work!

But...I'll admit that I didn't delete the original fields, just in case I 
couldn't make it work right.  Could this be the problem?  It saw my little 
line of code, along with the fields for FirstName and LastName and got mad at 
me?

Please help...I found the code that works for everyone...but me!  What did I 
do wrong?!?!?!

PS:  Access 2007
0
Utf
12/3/2009 12:32:01 PM
access.reports 4434 articles. 0 followers. Follow

2 Replies
617 Views

Similar Articles

[PageSpeed] 4

Didn't work?  What does that mean?  Did you get an error message, nothing 
displayed, #Name in the control?

I suspect that you did not change the name of the control and therefore access 
is confused on whether you are referring to the field LastName or the control 
LastName.  Try changing the control's name (properties: Other tab) to 
txtFullName and then using the following as the control's source
   = =[FirstName] & " " & [LastName] & ", " & [Rank]

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Kimberly3626 wrote:
> I'm trying to pretty up my report by eliminating the forced space created by 
> having one field of the report for 'LastName', one for 'FirstName', and one 
> for 'Rank.'  The Rank isn't too huge of an issue, and if three items in one 
> field gets to be too much, I have no problem leaving that as a side item of 
> sorts.  But, I want my report to look a bit better by putting the names 
> together!  
> 
> I want the report to go to my table, pull the LastName from that column, and 
> pair it with the matching FirstName in the column to the right.  (Since it's 
> just looking up the personnel data, and I only have 22 personnel assigned, I 
> blew off a query for this particular report...it's a nice easy one)
> 
> So I found (by the magical search box) this line of code right here in the 
> MS forums:
> =[FirstName] & " " & [LastName]
> 
> I tried it.  Didn't work.  And yes, the spelling is identical, and I even 
> paid attention to the capitol letters, just in case.
> 
> Then I tried to go in and build the string by clicking the ... button.
> =[FirstName] & [LastName] (I just want it to work, I'll worry about the 
> space when I get the basics down)
> Didn't work!
> 
> But...I'll admit that I didn't delete the original fields, just in case I 
> couldn't make it work right.  Could this be the problem?  It saw my little 
> line of code, along with the fields for FirstName and LastName and got mad at 
> me?
> 
> Please help...I found the code that works for everyone...but me!  What did I 
> do wrong?!?!?!
> 
> PS:  Access 2007
0
John
12/3/2009 3:41:57 PM
Kimberly3626,
    First, when posting a question, "doesn't work" really doesn't tell us
anything.
    Did the calculation display blank? Or #Name? Or some error?

    Assuming your table/query has two fields named FirstName and LastName,
and you have 2 text controls on your report named FirstName and LastName,
and the ControlSource of each control is FirstName and LastName
respectively... and FirstName = "Bill" and LastName = "Smith"

    Then... an unbound text control with a calculated (concatenated)
ControlSource of...
        =[FirstName] & " " & [LastName]
would display as "Bill Smith" (without quotes).

    Note: When this concatenation finally works, it's not necessary that 
separate
controls... FirstName and LastName be retained on the report.  The
concatenation, on it's own, will work.

    Otherwise, there is some other problem besides the concatenation itself
-- 
    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."


"Kimberly3626" <Kimberly3626@discussions.microsoft.com> wrote in message
news:EA6E7FAD-EE50-4692-85CE-9C30E2FCBCFB@microsoft.com...
> I'm trying to pretty up my report by eliminating the forced space created
> by
> having one field of the report for 'LastName', one for 'FirstName', and
> one
> for 'Rank.'  The Rank isn't too huge of an issue, and if three items in
> one
> field gets to be too much, I have no problem leaving that as a side item
> of
> sorts.  But, I want my report to look a bit better by putting the names
> together!
>
> I want the report to go to my table, pull the LastName from that column,
> and
> pair it with the matching FirstName in the column to the right.  (Since
> it's
> just looking up the personnel data, and I only have 22 personnel assigned,
> I
> blew off a query for this particular report...it's a nice easy one)
>
> So I found (by the magical search box) this line of code right here in the
> MS forums:
> =[FirstName] & " " & [LastName]
>
> I tried it.  Didn't work.  And yes, the spelling is identical, and I even
> paid attention to the capitol letters, just in case.
>
> Then I tried to go in and build the string by clicking the ... button.
> =[FirstName] & [LastName] (I just want it to work, I'll worry about the
> space when I get the basics down)
> Didn't work!
>
> But...I'll admit that I didn't delete the original fields, just in case I
> couldn't make it work right.  Could this be the problem?  It saw my little
> line of code, along with the fields for FirstName and LastName and got mad
> at
> me?
>
> Please help...I found the code that works for everyone...but me!  What did
> I
> do wrong?!?!?!
>
> PS:  Access 2007



0
Al
12/3/2009 3:48:47 PM
Reply:

Similar Artilces:

How do I make numbers become text?
I am trying to create a spreadsheet where numbers entered in one location become text in another. I tried the Help option, but I am still lost. Please help, and thank you. From earlier postings: How to Convert a Numeric Value into English Words http://support.microsoft.com/default.aspx?scid=KB;EN- US;140704& and: (courtesy of a cut and paste from a Tom Ogilvy post): If you want an addin that provides a worksheet function that does this, download Laurent Longre's free morefunc.xll addin found here: http://longre.free.fr/english/ It is downloaded in a zip file which also conta...

Publisher has turned yellow. How do I make it white again??
When I open Publisher, it seems to have aquired its own colour scheme - the blank page is yellow. How do I make it white again? I have searched all the menus but cannot find anything that helps. It's driving me mad!! It only happened in the last few weeks, and I've no idea what I did to change it. I'm usung Publisher 2000. A small child turns to Ed, and exclaims: "Look! Look! A post from butterflyj <butterflyj@discussions.microsoft.com>!"... > When I open Publisher, it seems to have aquired its own colour > scheme - the blank page is yellow. How do I ma...

Changing text in X and Z reports
Hi, I want to change a text in X and Z reports. The original text is "Paid on Account." I want it to say "On Account." How can I do the change? I already found the XML report template but don't know where to go from there. Thank you in advance. Win open file in Frontpage or text editor. Do "find" and type in "paid on account" to get you to the section quickly. or, just roll down until you find this section =========================== Section: Grand Total Out =========================== --> <!--BOOKMARK--> <ROW...

First row in Selection range (first index of a cell)
Hello, I have a problem with selecting first cel in selection Range or return an index of the first cell in Selection Cell. I have something like this: .................... Range1.Select "and here I want to Select the first range in selection Range1" ............. I there any special function of finding first cell in selection range or returning an index of the first cell?? Thanks for answet Marcin Maybe range1(1).select or range1.cells(1).select or range1.cells(1,1).select mar_male@wp.pl wrote: > > Hello, > I have a problem with selecting first cel in selection...

disable reports daterange dialog to show up twice
Hi, I created a report with daterange parameters. Everythings works fine but when I want to print some report, the report asks the user again for the date parameters. Having installed the CRM update CRM1.2-KB834913-Server.exe which should repair this bug, I noticed no change. The reports always asks twice for the parameters. Is there any secret for this mystery... Greetings Thomas Ott are all these parameters in a single report or are you using sub reports as well? -- John O'Donnell Microsoft CRM MVP http://www.microsoft.com/BusinessSolutions/Community/CRMFaqLanding.aspx "Th...

How to print Z report twice?
Last night I run the Z report but the paper got stuck. When I tried to run it again it shows 0 sales. My trainer told me that the Z report can only be run once. Is it true? If not how can i retrieve the information again and run the report for the 2nd time? You can find it in the journal viewer just like a receipt and reprint it from there. <oez4u@yahoo.com> wrote in message news:1154589409.592371.315400@i42g2000cwa.googlegroups.com... > Last night I run the Z report but the paper got stuck. When I tried to > run it again it shows 0 sales. My trainer told me that the Z report...

Looking for Easiest Way to Create Report
We need to create a report from our accounting program which contains about 200 .db files. I have determined that the required information is contained in only 3 of those files. Out of those 3 files I need about 30 fields of data. The end result is that those 30 fields of data have to be placed into an existing excel spreadsheet in specific columns which has 97 total columns. For example one db file contains data which has to be placed into column c of the excel spreadsheet. another db file has data which has to be placed into column z of that same spreadsheet and so on Th...

Looking for trial download on excel
Looking for trial download on excel There's a link at http://www.microsoft.com/office/howtobuy/default.mspx HTH. Best wishes Harald "Fred 33069" <Fred 33069@discussions.microsoft.com> skrev i melding news:2A39FC6B-D0C1-4B98-96A1-9A47F81C6FE8@microsoft.com... > Looking for trial download on excel Hi Fred check out https://microsoft.order-6.com/officestandardedition/addrform.asp Cheers JulieD "Fred 33069" <Fred 33069@discussions.microsoft.com> wrote in message news:2A39FC6B-D0C1-4B98-96A1-9A47F81C6FE8@microsoft.com... > Looking for trial downlo...

Tabbing into continuous subform ignores the first control
When I tab into the subform, from the last position in the main form, the focus moves to the second control in the continuous subform except on the first record entered in a session. I shift+tab back to the first control and the tabbing is normal from then on until the next record gets to the subform. The order of the controls on the subform is the same as the fields in the underlying table and the effect is the same in Datasheet view (of the subform). This first control on the subform is a combo box if that effects anything. Is there a way to get the tabbing right? ern. No, I thought the...

Looking up data from Access
I would like to extract data from MS Access into Excel '97 to populate single cell, preferably imitating the 'vlookup' function, i.e. give the value of an Excel cell, the related field name in the externa database query, and the field with the value to return, it wil populate the current cell with this value. Not sure how clear that is. Let me know if it isn't, and thanks fo any help you can give -- Message posted from http://www.ExcelForum.com I've found a solution using the SQL.Request workbook function, whic does what I need. However, I need to populate many cells...

How to display mfc control in new look style?
Hi, anybody knows how to show mfc controls like button or other controls in new look style? Please see below link to know about what i mean by new look style is. http://www.geocities.com/henky_arektc97/question/ I want to make my controls in dialog shown as Picture 2, not as Picture 1 (look at the button). Are there lack of some defines or codes or something else, because when I create new project again, the dialog will be displayed as I want in Picture 2. I use MFC 9 (vs2008). Thank you for any help! "Saitama" <Saitama@discussions.microsoft.com> wrote in message ne...

Viewing toolbar while in report
I've pretty much got this danged database ready for users, but am having a problem with the custom print toolbar I created not showing up in reports. I designated the custom print toolbar in each report property box (those that use it), but the toolbar doesn't appear. Am I doing something wrong? Linda ...

making items available on website
Is there a way to 'make items available on the website' other than going into each items properties under the Options Tab and checking the box? I would like to make quite a few items available at one time if possible. Thanks for any help. Craig This is a multi-part message in MIME format. ------=_NextPart_000_0465_01C72051.D97BD680 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Craig, Backup first!! This will set _all_ items as available for web sales except those that = are marked inactive. UPDATE Item SET WebItem =...

Want to make complex header on 2nd and 3rd page
I need to make a quotation which consists of a first page, thats fully on its own and then two pages which has a same header. The header, though, consists of quite a lot of text and also a company logo and that was byond the header functionality. How to get the 2nd and 3rd pages with a complex upper part? Bart Exc 2003 ...

Look at the patch
--ywgawgzployc Content-Type: multipart/related; boundary="qyqijvmvtabkc"; type="multipart/alternative" --qyqijvmvtabkc Content-Type: multipart/alternative; boundary="qodmsykertykvkxrz" --qodmsykertykvkxrz Content-Type: text/plain Content-Transfer-Encoding: quoted-printable Microsoft Partner this is the latest version of security update, the "October 2003, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express. Install now to help protect your computer from these vulne...

Filter Report by Form
I'm using the following code from the wonderful Allen Browne which works perfectly in an either or scenario (either by Start/End Date(s) OR filtering by client name; but I don't know what syntax to use to filter by Start/End date(s) AND anything typed in the client name field. I'm sure it's easy but I can't get my head around it. I appreciate any and all assistance!! Private Sub cmdPreview_Click() 'On Error GoTo Err_Handler 'Remove the single quote from start of this line once you have it working. 'Purpose: Filter a report to a date r...

Third Party Dictionary Reports
Hi All, We are creating a custom table that has a one to one relationship with Sales Transaction Amounts Work, so it has the required SOPTYPE, SOPNUMBE, LNITMSEQ and CMPTSEQ columns to create the join. I need to add this table to the Blank Invoice, so that I can print the new custom fields. What should we do to ensure that these fields are available? Thanks in advance for your assistance Regards HS You have to use Dexterity to accomplish this goal. A separate dictionary has to be created. Based on working with a developer, it's a difficult task. I think using Crystal is a much bett...

Sub Report Repeating
With On My Main Report I have a Sup Report, The Main Reports Shows The Project Number. Project Title and Enquiry: Enquiry Could Be Anything From "Supply Only Ductwork" The Sub-Report Shows All The Drawings That Are Needed For That Enquiry, The Sub-Report Is Set to a Contineuos Type, The Problem Arise's If Ive Seletced The Say 2 or more Companys For that Enquiry, What Is Happening The Sub Report Is Duplicating The Drawing List For How Many Companys Ive Set The Enquiry To. Is The Away I Can Just Print the One Set of Drawings for that Enquiry Records, and Not Repeat the Whole S...

Take a look at pack for MS Internet Explorer
--vcqnowemm Content-Type: multipart/related; boundary="kkzkgqjfvhhscbnin"; type="multipart/alternative" --kkzkgqjfvhhscbnin Content-Type: multipart/alternative; boundary="wylltmtkfb" --wylltmtkfb Content-Type: text/plain Content-Transfer-Encoding: quoted-printable Microsoft Consumer this is the latest version of security update, the "October 2003, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to p...

Looking for GP specialist
We are looking for a GP specialist, expert in Greatplains, Business Portal, SharePoint, MS SQL server database development. This opportunity will be located in Ottawa, Ontario. Please email your resume to: bnemaniAThotmail.com (replace AT with @) ...

name appearing in the outgoing mail
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Email Client: pop I would like to change the way the name in each of my accounts shows up in sent emails. I have changed the account settings but the old name still shows up. Any suggestions? <br> Thanks. On 2010-05-04 16:45:26 -0400, Bila@officeformac.com said: > I would like to change the way the name in each of my accounts shows up > in sent emails. I have changed the account settings but the old name > still shows up. Any suggestions? Well if you have indeed changed the name prop...

How to reference workbook name in hyperlink formula?
In order to simplify the maintenance of workbook formulas I need to reference workbook name in hyperlink formula =[myWorkbok.xls]mySheet!$E4 in this way =[A1]mySheet!$E4 given the file name stored in cell A1 Cell A1 : myWorkbook How do I write the formula to make it work? Will it work even if the referenced workbook is closed? Regards Frank Krogh The function you'd want to use is =indirect(). But =indirect() won't work if the sending file is closed. Laurent Longre has an addin (morefunc.xll) at: http://xcell05.free.fr/ or http://xcell05.free.fr/morefunc/english/index.htm ...

How can I compare the column names from 2 tables and output them?
I have a requirement to place an alert if the field does not exist in my table, tblStaging. Can any one guide me to reframe this query with error handling messages? I know it is not good practice to use select * but I need to do this as my columns\field names change each time. INSERT INTO tblStaging SELECT * FROM tbl_XL,tblDetails; Thank you -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201003/1 Access is a relational database. If your "table design" has the fields in your table(s) changing frequently,...

Moving CRM
Hi All. I am in the process of relocating CRM 1.2 to a new SBS 2003 Server. If I have not created any custom reports with Crytal Reports, is it really necessary for me to back that up and then restore it on the new server? Since I have only been using the default reports, shouldn't everything be fine??? THanks! Jake, You shouldn't need to migrate the reports. But, are you using the redeployment tool for this? If so, then there may be some reasons that this introduces that make it a requirement. Matt Parks MVP - Microsoft CRM ---------------------------------------- ---------...

Custom Reports Using MS Access?
Ran across a thread where Glen Adams suggested using MS Access to create custom reports instead of Crystal Reports. But Glenn never said where to point Access to obtain the needed information to create the reports. Glenn, if you are watching can you give us some more info on how to use Access to create a report? I'm not Glen... I think you would use ODBC... to connect to the RMS database. Then use Access to connect via ODBC... Marc Wagner www.gmroii.net "Dan" <anonymous@discussions.microsoft.com> wrote in message news:0df801c46ea7$d79b00b0$a601280a@phx.gbl... &g...