Sql In Access

[siddhartha mulpuru]

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

[Bernard Peek]

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.