Criteria question
From: VJ-mike (anonymous_at_discussions.microsoft.com)
Date: 07/09/04
- Next message: Ken Snell: "Re: DMax alternative?"
- Previous message: Dale Peart: "Re: combining tables and linking records with queries"
- In reply to: JT: "Criteria question"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 9 Jul 2004 15:48:30 -0700
sorry, just curious - JT?
Terrill?
if so, an old aquaintance from the sewers is watching you,
lol!
>-----Original Message-----
>I have a query with 2 tables joined. Table A is much
>larger than Table B.
>
>Each transaction in Table B contains a group number.
Each
>record has only one group number. However a group number
>can appear in a number of different transactions. The
>group numbers in Table B are less than the total
>population in Table A.
>
>I only want to select records in Table A if the group
>number appears i Table B.
>
>I can write the criteria with an IN command but I'm
>looking for suggestions on writing the criteria so it
>looks to the group numbers in Table B and does not
require
>any manual intervention.
>
>Thanks for the help.
>.
>
- Next message: Ken Snell: "Re: DMax alternative?"
- Previous message: Dale Peart: "Re: combining tables and linking records with queries"
- In reply to: JT: "Criteria question"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
