David,
If you look at Queries->NEW, you will see there is a Wizard option to
create a duplicated values and a non-duplicated values query. Follow
the instructions of your wizard, they know what to do :)
Brett
At 06:43 24/08/06, you wrote:
>Hello all,
>
>I have a question about help with a query.
>
>I have a database with just two tables. I am simply just trying to
>create a query so that it will show me who is in BOTH tables plus the
>other fields I want.
>
>For example in TABLE1 I have a column of last names. In TABLE2 I also
>have a column of last names. The query would then include those
>people who are in BOTH TABLES 1 and 2.
>
>How would one go about creating this?
>
>Thanks
>David
>
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>--
>No virus found in this incoming message.
>Checked by AVG Free Edition.
>Version: 7.1.405 / Virus Database: 268.11.3/423 - Release Date: 18/08/06
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.11.3/423 - Release Date: 18/08/06
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
