Office Software Thread, create import csv in Technical; Hi, I used to have an access query which changed the SIMS year list extract into a form which I ...
2nd September 2009, 05:19 PM #1
create import csv
Hi, I used to have an access query which changed the SIMS year list extract into a form which I could upload into active directory. I need an access query which will do the following
currently the export looks like "John Smith"
What I want is the field to look like "09SmithJ"
I know this is simple, but it's bugging me.
2nd September 2009, 09:27 PM #2
- Rep Power
I've not touched Access in *years*, but the following in Excel would do it if you had 'John' in A1 and 'Smith' in B1, stick this in C1
= "09" & B1 & LEFT(A1,1)
Thanks to grumpy_git from:
KWestos (3rd September 2009)
By ful56_uk in forum Windows
Last Post: 20th July 2009, 06:06 PM
By PEO in forum Windows Server 2008
Last Post: 3rd June 2009, 01:50 PM
Last Post: 21st May 2009, 09:34 AM
By damienharrison in forum Web Development
Last Post: 3rd February 2009, 12:40 PM
By stephen.loader in forum MIS Systems
Last Post: 14th January 2008, 12:32 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)