[mso] Re: (Access) LOOKUP
- From: "Dian Chapman" <dian@xxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Thu, 9 May 2002 18:52:42 -0500
Sorry, maybe I miss understood as I was reading this fast. But I thought
you asked about sorting by a field other than it was being sorted by? In
the lookup query line, after the wizard query you have inserted, you can
add the SQL call of ORDER BY and then provide the table.field range for
the field you want sorted.
Like say you have two fields and you want the NAME of the field showing
up, but of course have the ID linked. Maybe you'd prefer the list
showing up in alpha order by name???? If that's not what you meant,
sorry...go with James' suggestion. And yes, this is done in the table
design mode.
Dian Chapman
Technical Consultant,
Microsoft MVP & TechTrax Editor
Tutorial web site: http://www.mousetrax.com
TechTrax Ezine: http://www.mousetrax.com/techtrax/
Word MVP support site: http://www.mvps.org/word
Microsoft support groups: http://support.microsoft.com
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Charles Ippolito
Sent: Thursday, May 09, 2002 4:11 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: (Access) LOOKUP
Need a little better description as to what you mean. Is there an ORDER
BY field? And, how does this relate to the actual value that is
returned?
Also, please keep in mind that I am trying to do this is the TABLE, not
a FORM... if that changes matters.
---Charlie
----- Original Message -----
From: Dian Chapman
To: mso@xxxxxxxxxxxxx
Sent: Thursday, May 09, 2002 4:01 PM
Subject: [mso] Re: LOOKUP
I believe you have to add ORDER BY at the end of the look up field and
enter the sort [table].[field] order you want?
Dian Chapman
Technical Consultant,
Microsoft MVP & TechTrax Editor
Tutorial web site: http://www.mousetrax.com
TechTrax Ezine: http://www.mousetrax.com/techtrax/
Word MVP support site: http://www.mvps.org/word
Microsoft support groups: http://support.microsoft.com
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Charles Ippolito
Sent: Thursday, May 09, 2002 1: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
*************************************************************
*************************************************************
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:
