Prev: Custom Counter Question (Repost)
Next: Inverted Query
From: anlu on 7 Nov 2009 18:41
Steve,

I think the easiest way is to create a new query, that joins tblPerson with
the first query on PersonIDNum - this is a straightforward query and you can
simply select the first and last names from tblPerson.

Regards,
anlu

> Anlu,
> That gave me exactly what I was expecting to get. Thanks for that. Now I
> have another related question, if I may.
>
> This returns back the PersonIDNum, which corresponds to the person's record
> tblPerson. I want to use this query to lookup the first and last names in
> tblPerson and display them in a list box. How would I modigy this query to
> return that?
>
> When I tried adding the tblPerson in the Query Design, it stopped returning
> any records.
>
> I really appreciate the help.
>
> Steve
>

From: Steve Haack on 8 Nov 2009 00:08
That did it. Thanks for all your help.

Steve

"anlu" wrote:

> Steve,
>
> I think the easiest way is to create a new query, that joins tblPerson with
> the first query on PersonIDNum - this is a straightforward query and you can
> simply select the first and last names from tblPerson.
>
> Regards,
> anlu
>
> > Anlu,
> > That gave me exactly what I was expecting to get. Thanks for that. Now I
> > have another related question, if I may.
> >
> > This returns back the PersonIDNum, which corresponds to the person's record
> > tblPerson. I want to use this query to lookup the first and last names in
> > tblPerson and display them in a list box. How would I modigy this query to
> > return that?
> >
> > When I tried adding the tblPerson in the Query Design, it stopped returning
> > any records.
> >
> > I really appreciate the help.
> >
> > Steve
> >
>
First  |  Prev  | 
Pages: 1 2
Prev: Custom Counter Question (Repost)
Next: Inverted Query