By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,705 Members | 1,815 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,705 IT Pros & Developers. It's quick & easy.

Update Query

P: 1
I am trying to write an update query that will take the First Initial from my first name field add it to the Last name of the last name field and then add it to the userid. So for the table below the Login should be DYoungpeter1.

My query looks like this:
Update Users
Set Login = 'First Initial + LastName + UserID'
And CStr(UserID)
Where FirstName IS NOT NULL

My table looks like this and I keep getting -1 back in the login.

Oct 8 '06 #1
Share this Question
Share on Google+
1 Reply


100+
P: 143
Where do you strip off the first character of the FirstName? And, why is Login already true?
Oct 9 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.