Re: ORDER BY {Lookup field} gets "Lookup has no default value"
- From: "Ian Groves" <ian@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 12 Dec 2007 00:58:00 -0000
Thanks, im using an Accesss MDB file so should be fine.
Ian
"Bill Todd" <no@xxxxxx> wrote in message
news:475f2694@xxxxxxxxxxxxxxxxxxxxxxxxx
Assuming that the database you are using supports inner joins you can
do:
SELECT C.*, L.CLIENTLOOKUP FROM CLIENTS C JOIN LOOKUPTABLE L
ON C.CLIENTID = L.CLIENTID
ORDER BY L.CLIENTLOOKUP
--
Bill Todd (TeamB)
.
- References:
- ORDER BY {Lookup field} gets "Lookup has no default value"
- From: Ian Groves
- Re: ORDER BY {Lookup field} gets "Lookup has no default value"
- From: Bill Todd
- ORDER BY {Lookup field} gets "Lookup has no default value"
- Prev by Date: ORDER BY {Lookup field} gets "Lookup has no default value"
- Next by Date: UpdateStatus is not returning correct value
- Previous by thread: Re: ORDER BY {Lookup field} gets "Lookup has no default value"
- Next by thread: UpdateStatus is not returning correct value
- Index(es):
Relevant Pages
|
