Simple query

[deergirl]

Hi,

Disclaimer - new to access

I would like to create a table from 2 existing tables.
1. contains a deer ID number and the sex of the animal
2. contains the deer ID number and encounter date (10 rows of same ID with different dates)

I would like to know the sex of deer for every encounter entry.

How can a make a new table to include sex of animal, ID, and encounter date?

Thanks!

[orange]

You would have 2 tables

tblDeer with info about the deer --
DeerID -- unique identifier of a deer (Primary Key)
,name
, DateOfBirth
, sex....

and
tblEncounters with
EncounterID <---Primary Key of this table
,DateOfEncounter
,LocationOfEncounter
,DeerId <----foreign key gives your the ability to join the tables and select related information
, other encounter specific info


Typical data in table
TblDeer

1,Bambi, 23/6/2013,F
2,Bob,11,10,2012,M

tblEncounters
1,21/10/2013, GenoaCity,1
2,22/10/2013,KMart,1
3,30/10/2013,WalMart,1
4,14/03/2013,Kmart,2


Research Normalization.

[deergirl]

I worded the question poorly, it is edited now.

[June7]

Don't make table. Make query. Use query builder. Basic Access functionality. Access Help has guidelines on using the query builder.