That's handy to know. Those 2 word fields with spaces were preset by the organsation in their administration software package - which I am able to tap into to extract data (legitimately!! )
;-Dz
User Profile
Collapse
-
Thanks again - i have now been able to do this login at another work place....
John Smith = johnsm
:-D...Leave a comment:
-
I have corrected it - i needed to do....
Login: LCase(left([Preferred Name],1)) & LCase([Family Name])
The extra bracket is needed around the fields due to them having two words.
Thanks for the tip.
:-DzLeave a comment:
-
Thank You
For my query I typed:
Login: lcase(left(Pref erred Name,1)) & lcase(Family Name)
However, I get an error message - "The expression you entered contains an invalid syntax. You may entered an operand without an operator"
And after that, "NAME" in the 'Preferred Name' field is highlighted.Leave a comment:
-
Create lower case login from 2 Upper Case Fields
Hello
I am using Access97 - workplace requirement.
I want to create a query where I can generate a login field that takes the 1st letter of the 1st field (PREFERRED NAME) and combine it with the entire 2nd field (FAMILY NAME)
eg - JOHN SMITH = jsmith
Thanks
:-Dz
No activity results to display
Show More
Leave a comment: