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

Sql In Access

P: n/a
Hi,

I have a table in Access database named Client

Table Design:

Clientid, fname, lname, userid

example data:

1 , john, Dunn,

2, tom, connor

..
..

..

The field userid is empty for all records. I would like to populate
the userID
using the fname and lname fields of the table so after conversion the
table data (maybe by running some script) should be like
1 , john, Dunn, john.dunn

2, tom, connor,tom.connor
How do i implement this in the Access database. Please Advise.

Any help is really appreciated.

Thanks
Sid
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
In message <78**************************@posting.google.com >, siddhartha
mulpuru <ju******@yahoo.com> writes
Hi,

I have a table in Access database named Client

Table Design:

Clientid, fname, lname, userid

example data:

1 , john, Dunn,

2, tom, connor

.
.

.

The field userid is empty for all records. I would like to populate
the userID
using the fname and lname fields of the table so after conversion the
table data (maybe by running some script) should be like
1 , john, Dunn, john.dunn

2, tom, connor,tom.connor
How do i implement this in the Access database. Please Advise.

You don't need SQL. Create a new query, make it an update query.

Select the userid field.

In the "Update To" section under that put [fname] & "." & [lname]

Run the query.


--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.