Usernames/passwords

[Becky]

Is there a way to set username fields value equal to two
other field values? I know that if I was using a form in
Access I could have txtusername = txtFname and txtZip but
I am getting the information from ASP. Can the database do
it directly or do I need to look at a VBScript or
JavaScript function?

 

[Michel Walsh]

Hi,


SELECT (FirstName & " " & LastName) As FullName FROM somewhere WHERE
something



with Jet; with MS SQL Server, use + rather than &.



Hoping it may help,
Vanderghast, Access MVP