[mso] Re: Access LOOKUP in a table
- From: "sukii" <lskii@xxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Fri, 10 May 2002 09:49:02 +0800
Perhaps it would make things easier should there be some indication at the
beginning of each subject line (for future mails) of whether it is an
Access, Excel, PP, Outlk or Word related post, eg, some abbreviations, XL,
PP or even the full word like "Word" or "Outlook" maybe? Just a thought...
good morning to all. :) Have a good weekend.
----- Original Message -----
From: "Linda Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
To: <mso@xxxxxxxxxxxxx>
Sent: Friday, 10 May, 2002 03:27
Subject: [mso] Access LOOKUP in a table
>
> Hi Charlie...I just added Access to the subject line of your post so the
> Excel people can ignore it and the Access people might see it
>
> Of course, I'm an Excel person so I won't do you any good LOL
>
> Linda
> Publisher ~ ABC ~ All 'Bout Computers
> Owner ~ Linda's Computer Stop
> www.personal-computer-tutor.com
> Author/Teacher ~ MS Office EBooks/Classes
> www.personal-computer-tutor.com/services.htm
>
>
> -----Original Message-----
> From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
> Behalf Of Charles Ippolito
> Sent: Thursday, May 09, 2002 2:58 PM
> To: MSO
> Subject: [mso] LOOKUP
>
>
> One of my tables contains a field, we'll call it field A. When entering
> data on field A, I want to do a LOOKUP to ensure that the only data that
> can be entered is what is in another table. So I use the LOOKUP wizard,
> and create a LOOKUP using 3 fields from another table. When entering the
> data, it shows the 3 columns from the lookup table, but when I select
> one of the choices, it returns the value of the first field. I want it
> to return the value of the second field. I know I can just change the
> order, but I want it alphabetized by the first column, but the second
> column to be the return field.
>
> Any help is greatly appreciated!
>
> ---Charles
>
>
> *************************************************************
> PLEASE READ!!!!
>
> You are receiving this mail because you either subscribed to
mso@xxxxxxxxxxxxx or to it's earlier version,
MicrosoftOffice@xxxxxxxxxxxxxxxx
>
> To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx
with a subject line that says "unsubscribe" (without the quotes). Do not
put unsubscribe IN CAPS. Screaming doesn't get you out any faster and the
caps prevent the function from working.
>
> To change your email settings to digest or vacation (no mail), visit the
group's homepage for full instructions.
>
> //www.freelists.org/webpage/mso
> *************************************************************
>
*************************************************************
PLEASE READ!!!!
You are receiving this mail because you either subscribed to mso@xxxxxxxxxxxxx
or to it's earlier version, MicrosoftOffice@xxxxxxxxxxxxxxxx
To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with
a subject line that says "unsubscribe" (without the quotes). Do not put
unsubscribe IN CAPS. Screaming doesn't get you out any faster and the caps
prevent the function from working.
To change your email settings to digest or vacation (no mail), visit the
group's homepage for full instructions.
//www.freelists.org/webpage/mso
*************************************************************
Other related posts:
