Re: updating field with data from other fields

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Try an Update query to update your EMail field with...
= [LastName] & Left([FirstName],1) & "@abcd.com"
hth
Al Camp

"cwr" <cwr@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C545C78C-3CB4-46A9-A96F-EA189601BE9F@xxxxxxxxxxxxxxxx
>i have an access database....it has first name, last name and a field for
> email address of every entry, but the email address is empty...i need to
> somehow concatenate the last name, the first initial of the first name and
> a
> hard coded literal that will be the same for all....
>
> i.e. JonesG@xxxxxxxx
>
> the only thing different will be the lastname and first letter of first
> name
>
> what's the best way to do this...?


.

Relevant Pages

  • Re: convert yes/no values to text
    ... In the query design grid, ... Al Camp ... Prev by Date: ...
    (microsoft.public.access.forms)
  • Re: Date Parameters
    ... Al Camp ... I have report that displays information grouped by ... Prev by Date: ...
    (microsoft.public.access.forms)
  • Re: Count logic question
    ... In the cell directly below the last entry in row B, ... HTH, ... PokerZan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23480 ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: If table has no records?
    ... > Al Camp ... Prev by Date: ...
    (microsoft.public.access.formscoding)
  • Re: Field data between tables
    ... Al Camp ... > Sorry for the rookie question. ... Prev by Date: ...
    (microsoft.public.access.gettingstarted)