I have a student who has a hyphenated first name. If I concatenate the
name like this: StudentName:([StudentLastName] & ", " &
[StudentFirstNam e]), it works as expected. If, however, I try to get
the first name first by concatenating like this: StudentName:
([StudentFirstNam e] & " " & [StudentLastName]), only the first name
appears.
I sure would appreciate any help!
Mary 7 2783
It should work either way.
Do you have any Criteria in this query? There are known problems with
criteria that contains a dash: http://support.microsoft.com/kb/271661/en-us
What language are you using?
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Mary" <mm**********@m sn.comwrote in message
news:11******** **************@ v33g2000cwv.goo glegroups.com.. .
>I have a student who has a hyphenated first name. If I concatenate the
name like this: StudentName:([StudentLastName] & ", " &
[StudentFirstNam e]), it works as expected. If, however, I try to get
the first name first by concatenating like this: StudentName:
([StudentFirstNam e] & " " & [StudentLastName]), only the first name
appears.
I sure would appreciate any help!
Mary
On Mar 13, 10:11 am, "Allen Browne" <AllenBro...@Se eSig.Invalid>
wrote:
It should work either way.
Do you have any Criteria in this query? There are known problems with
criteria that contains a dash: http://support.microsoft.com/kb/271661/en-us
What language are you using?
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Mary" <mmcgilliv...@m sn.comwrote in message
news:11******** **************@ v33g2000cwv.goo glegroups.com.. .
I have a student who has a hyphenated first name. If I concatenate the
name like this: StudentName:([StudentLastName] & ", " &
[StudentFirstNam e]), it works as expected. If, however, I try to get
the first name first by concatenating like this: StudentName:
([StudentFirstNam e] & " " & [StudentLastName]), only the first name
appears.
I sure would appreciate any help!
Mary- Hide quoted text -
- Show quoted text -
No, I have no criteria in the query. I get the same results if I
create a query that only lists these fileds.
I am using Access 2003.
Switch the query to SQL View (View menu, from query design.)
Paste the SQL statement here.
I can't understand what's wrong, because I do this kind of thing all the
time.
What language setting do you have under:
Tools | Options | General | New database sort order
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Mary" <mm**********@m sn.comwrote in message
news:11******** **************@ c51g2000cwc.goo glegroups.com.. .
On Mar 13, 10:11 am, "Allen Browne" <AllenBro...@Se eSig.Invalid>
wrote:
>It should work either way.
Do you have any Criteria in this query? There are known problems with criteria that contains a dash: http://support.microsoft.com/kb/271661/en-us
What language are you using?
"Mary" <mmcgilliv...@m sn.comwrote in message
news:11******* *************** @v33g2000cwv.go oglegroups.com. ..
>I have a student who has a hyphenated first name. If I concatenate the
name like this: StudentName:([StudentLastName] & ", " &
[StudentFirstNam e]), it works as expected. If, however, I try to get
the first name first by concatenating like this: StudentName:
([StudentFirstNam e] & " " & [StudentLastName]), only the first name
appears.
I sure would appreciate any help!
Mary- Hide quoted text -
- Show quoted text -
No, I have no criteria in the query. I get the same results if I
create a query that only lists these fileds.
I am using Access 2003.
On Mar 13, 11:10 am, "Allen Browne" <AllenBro...@Se eSig.Invalid>
wrote:
Switch the query to SQL View (View menu, from query design.)
Paste the SQL statement here.
I can't understand what's wrong, because I do this kind of thing all the
time.
What language setting do you have under:
Tools | Options | General | New database sort order
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org."Mary" <mmcgilliv...@m sn.comwrote in message
news:11******** **************@ c51g2000cwc.goo glegroups.com.. .
On Mar 13, 10:11 am, "Allen Browne" <AllenBro...@Se eSig.Invalid>
wrote:
It should work either way.
Do you have any Criteria in this query? There are known problems with
criteria that contains a dash: http://support.microsoft.com/kb/271661/en-us
What language are you using?
"Mary" <mmcgilliv...@m sn.comwrote in message
>news:11******* *************** @v33g2000cwv.go oglegroups.com. ..
I have a student who has a hyphenated first name. If I concatenate the
name like this: StudentName:([StudentLastName] & ", " &
[StudentFirstNam e]), it works as expected. If, however, I try to get
the first name first by concatenating like this: StudentName:
([StudentFirstNam e] & " " & [StudentLastName]), only the first name
appears.
I sure would appreciate any help!
Mary- Hide quoted text -
- Show quoted text -
No, I have no criteria in the query. I get the same results if I
create a query that only lists these fileds.
I am using Access 2003.- Hide quoted text -
- Show quoted text -
Thanks so much for your help, Allen.
I had an index on the field. I removed the index and retyped the first
name in the table. Now it works. This is so strange. I just realized
that there were other hyphenated first names that concatenated
correctly.
Here is my SQL:
SELECT ([StudentFirstNam e] & " " & [StudentLastName]) AS StudentName
FROM tblEAStudentInf ormation;
The language setting under:
Tools | Options | General | New database sort order
is "General"
Mary
I can't see anything wrong with that, Mary.
In the next column in query design, enter:
CharCount: Len([StudentFirstNam e] & " " & [StudentLastName])
Does it return the expected number of characters (including the space)?
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Mary" <mm**********@m sn.comwrote in message
news:11******** **************@ h3g2000cwc.goog legroups.com...
On Mar 13, 11:10 am, "Allen Browne" <AllenBro...@Se eSig.Invalid>
wrote:
>Switch the query to SQL View (View menu, from query design.)
Paste the SQL statement here.
I can't understand what's wrong, because I do this kind of thing all the time.
What language setting do you have under: Tools | Options | General | New database sort order
"Mary" <mmcgilliv...@m sn.comwrote in message
>> news:11******* *************** @c51g2000cwc.go oglegroups.com. ..
On Mar 13, 10:11 am, "Allen Browne" <AllenBro...@Se eSig.Invalid>
wrote: It should work either way.
>Do you have any Criteria in this query? There are known problems with criteria that contains a dash: http://support.microsoft.com/kb/271661/en-us
>What language are you using?
>"Mary" <mmcgilliv...@m sn.comwrote in message
>>news:11****** *************** *@v33g2000cwv.g ooglegroups.com ...
>I have a student who has a hyphenated first name. If I concatenate the
name like this: StudentName:([StudentLastName] & ", " &
[StudentFirstNam e]), it works as expected. If, however, I try to get
the first name first by concatenating like this: StudentName:
([StudentFirstNam e] & " " & [StudentLastName]), only the first name
appears.
I sure would appreciate any help!
Mary- Hide quoted text -
>- Show quoted text -
No, I have no criteria in the query. I get the same results if I
create a query that only lists these fileds.
I am using Access 2003.- Hide quoted text -
- Show quoted text -
Thanks so much for your help, Allen.
I had an index on the field. I removed the index and retyped the first
name in the table. Now it works. This is so strange. I just realized
that there were other hyphenated first names that concatenated
correctly.
Here is my SQL:
SELECT ([StudentFirstNam e] & " " & [StudentLastName]) AS StudentName
FROM tblEAStudentInf ormation;
The language setting under:
Tools | Options | General | New database sort order
is "General"
Mary
On Mar 13, 1:31 pm, "Allen Browne" <AllenBro...@Se eSig.Invalidwro te:
I can't see anything wrong with that, Mary.
In the next column in query design, enter:
CharCount: Len([StudentFirstNam e] & " " & [StudentLastName])
Does it return the expected number of characters (including the space)?
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Mary" <mmcgilliv...@m sn.comwrote in message
news:11******** **************@ h3g2000cwc.goog legroups.com...
On Mar 13, 11:10 am, "Allen Browne" <AllenBro...@Se eSig.Invalid>
wrote:
Switch the query to SQL View (View menu, from query design.)
Paste the SQL statement here.
I can't understand what's wrong, because I do this kind of thing all the
time.
What language setting do you have under:
Tools | Options | General | New database sort order
"Mary" <mmcgilliv...@m sn.comwrote in message
>news:11******* *************** @c51g2000cwc.go oglegroups.com. ..
On Mar 13, 10:11 am, "Allen Browne" <AllenBro...@Se eSig.Invalid>
wrote:
It should work either way.
Do you have any Criteria in this query? There are known problems with
criteria that contains a dash: http://support.microsoft.com/kb/271661/en-us
What language are you using?
"Mary" <mmcgilliv...@m sn.comwrote in message
>news:11******* *************** @v33g2000cwv.go oglegroups.com. ..
I have a student who has a hyphenated first name. If I concatenate
the
name like this: StudentName:([StudentLastName] & ", " &
[StudentFirstNam e]), it works as expected. If, however, I try to get
the first name first by concatenating like this: StudentName:
([StudentFirstNam e] & " " & [StudentLastName]), only the first name
appears.
I sure would appreciate any help!
Mary- Hide quoted text -
- Show quoted text -
No, I have no criteria in the query. I get the same results if I
create a query that only lists these fileds.
I am using Access 2003.- Hide quoted text -
- Show quoted text -
Thanks so much for your help, Allen.
I had an index on the field. I removed the index and retyped the first
name in the table. Now it works. This is so strange. I just realized
that there were other hyphenated first names that concatenated
correctly.
Here is my SQL:
SELECT ([StudentFirstNam e] & " " & [StudentLastName]) AS StudentName
FROM tblEAStudentInf ormation;
The language setting under:
Tools | Options | General | New database sort order
is "General"
Mary- Hide quoted text -
- Show quoted text -
Allen,
Ok, I finally figured out what happened and now it all makes sense.
And I feel kind of stupid because it has nothing to do with a
hyphenated field at all; that was a poor assumption on my part.
I went to a backup file and looked at the table with this student's
first name. His name is Kevin-Michael. When I placed my cursor at the
end of his name and hit "delete", the name "Michael" appears. The user
apparently entered Michael, changed their mind and entered "Kevin
Michael" without erasing the first Michael. So the concatenating
appeared not to be working since his first name was so long. When I
deleted the field and retyped the name, it obviously fixed the
problem. What I don't get, though, is why all I saw in the table, even
when I expanded the field, was "Kevin-Michael". The field size is only
25 characters.The extra 'Michael" only showed up when I hit the delete
key.
Anyway, thank you for your help. I read these posts often and you are
always so kind.I have learned so much from you and your website.
Mary
Great! Solved.
It's often sometime that makes sense in the end. And it's neat that you can
enlist Access to help you understand what's happening, like the calculated
query field giving the character count, or using TypeName() or the Immediate
Window (Ctrl+G.)
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Mary" <mm**********@m sn.comwrote in message
news:11******** **************@ h3g2000cwc.goog legroups.com...
On Mar 13, 1:31 pm, "Allen Browne" <AllenBro...@Se eSig.Invalidwro te:
>I can't see anything wrong with that, Mary.
In the next column in query design, enter: CharCount: Len([StudentFirstNam e] & " " & [StudentLastName])
Does it return the expected number of characters (including the space)?
-- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users -http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org.
"Mary" <mmcgilliv...@m sn.comwrote in message
news:11******* *************** @h3g2000cwc.goo glegroups.com.. .
On Mar 13, 11:10 am, "Allen Browne" <AllenBro...@Se eSig.Invalid>
wrote: Switch the query to SQL View (View menu, from query design.)
>Paste the SQL statement here.
>I can't understand what's wrong, because I do this kind of thing all the time.
>What language setting do you have under: Tools | Options | General | New database sort order
"Mary" <mmcgilliv...@m sn.comwrote in message
>>news:11****** *************** *@c51g2000cwc.g ooglegroups.com ...
On Mar 13, 10:11 am, "Allen Browne" <AllenBro...@Se eSig.Invalid>
wrote: It should work either way.
>Do you have any Criteria in this query? There are known problems with criteria that contains a dash: http://support.microsoft.com/kb/271661/en-us
>What language are you using?
>"Mary" <mmcgilliv...@m sn.comwrote in message
>>news:11****** *************** *@v33g2000cwv.g ooglegroups.com ...
>I have a student who has a hyphenated first name. If I concatenate the
name like this: StudentName:([StudentLastName] & ", " &
[StudentFirstNam e]), it works as expected. If, however, I try to
get
the first name first by concatenating like this: StudentName:
([StudentFirstNam e] & " " & [StudentLastName]), only the first
name
appears.
I sure would appreciate any help!
Mary- Hide quoted text -
>- Show quoted text -
No, I have no criteria in the query. I get the same results if I
create a query that only lists these fileds.
I am using Access 2003.- Hide quoted text -
>- Show quoted text -
Thanks so much for your help, Allen.
I had an index on the field. I removed the index and retyped the first
name in the table. Now it works. This is so strange. I just realized
that there were other hyphenated first names that concatenated
correctly.
Here is my SQL:
SELECT ([StudentFirstNam e] & " " & [StudentLastName]) AS StudentName
FROM tblEAStudentInf ormation;
The language setting under:
Tools | Options | General | New database sort order
is "General"
Mary- Hide quoted text -
- Show quoted text -
Allen,
Ok, I finally figured out what happened and now it all makes sense.
And I feel kind of stupid because it has nothing to do with a
hyphenated field at all; that was a poor assumption on my part.
I went to a backup file and looked at the table with this student's
first name. His name is Kevin-Michael. When I placed my cursor at the
end of his name and hit "delete", the name "Michael" appears. The user
apparently entered Michael, changed their mind and entered "Kevin
Michael" without erasing the first Michael. So the concatenating
appeared not to be working since his first name was so long. When I
deleted the field and retyped the name, it obviously fixed the
problem. What I don't get, though, is why all I saw in the table, even
when I expanded the field, was "Kevin-Michael". The field size is only
25 characters.The extra 'Michael" only showed up when I hit the delete
key.
Anyway, thank you for your help. I read these posts often and you are
always so kind.I have learned so much from you and your website.
Mary This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: nwheavyw8 |
last post by:
I am currently trying to write a simple PHP script that will split an
uploading file up into 500kb "chunks", then read and concatenate them
back together when accessed for download. I can't seem to be able to
find a way to split the file purely in PHP while it is in the middle of
uploading using the move_uploaded_file function.
I am trying to get it to store the file like so:
MySong.mp3 3mb
gets uploaded to my server in this...
|
by: Larry R Harrison Jr |
last post by:
I have designed databases but have never come across any complications due
to the ridiculous situation of a hyphenated last name. As a database
designer (very junior level) I disdain anything unwieldly, and consider this
unwieldly.
I haven't dealt with it, as I said, but I figure if I do, I'd simply design
the text field to not accept hyphens, so Smith-Barney would be stored as
SmithBarney, or even Smithbarney as I commonly have the...
|
by: Dixie |
last post by:
I have a problem using Dev Ashish's excellent module to concatenate the
results of a field from several records into one record.
I am using the code to concatenate certain awards onto a certificate at the
end of the year. I have the code working fine, except for the fact that
when I want to restrict the entries to awards between certain dates, even
though I can use the restriction in the query that shows the actual records,
when the...
|
by: Juan |
last post by:
Does any one know if there are reported bugs when concatenating strings?
When debugging each variable has the correct value but when I try to
concatenate them some values are missing (I can´t see them in the debugger).
After encoding the string (the sameone which complete value is not visible
from the debugger) all the values can be seen but they are spaced by big
amounts of zeros and use more that the 2048 bytes allocated. It is like if...
|
by: Elena |
last post by:
Hi,
I am filling in a combobox. I would like to concatenate two fields into the
data combo box and display "last name, first name"
I tried to displaymember = "employee_last_name" & ", " &
"employee_last_name", but it did not like that.
I can fill the combo box with either the first or the last, but I cannot
manage to concatenate it.
| |
by: Peter Michaux |
last post by:
Hi,
Since I can do this
document.defaultView.getComputedStyle(el, null).height;
why would I ever want to do this
document.defaultView.getComputedStyle(el,
null).getPropertyValue('height');
|
by: newfieskater |
last post by:
I have 1 table with multiple fields
Unit First Name Last Name # Pets Pet's Name
100 John Jackson 1 Oreo
200 Peter Smith 2 Molly and Candy
200 Elaine Smith 2 Molly and Candy
300 Susan Smith 2 Molly and Candy
400 Nedd ...
|
by: TheCoder |
last post by:
Why does this work:
It seems that we're concatenating two literals:
std::cout << greeting + name + " Hello " + "There" << std::endl;
but if you remove (greeting + name +), it doesn't work ?
|
by: renojim |
last post by:
I'm trying to concatenate a half dozen fields from an sql statement into a string, then loading the string in a select list. I can't seem to find a way to keep them 'lined up' - so if, for instance, I concatenate a name field and address field, I want the first letter of the first names to line up, and the first letter of the addresses to line up in my list box. I've been trying str_pad(), but can't get that to work for some reason - If I pad...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |