create a new table that pulls only unique values from a data table

I

Isac Malmgren

I have a table that list out an employee and their name for each pay period
they were paid, I want to use the ID number as a unique key to summarize and
sort the data but there are mutilple instances of the same ID number in my
original table. Is there a way to sort out only unique ID numbers?
 
J

Jeff Boyce

I'm not following...

What's the ID an ID of? The employee? The pay period?

By the way, if your table actually has employee name in every single pay
period record, you have a spreadsheet, not a relational database table.

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP
 
G

golfinray

You could add an autonumber field to the table. The autonumbers would be
unique but you may want to have a unique employee id number, either assigned
by you or a ssn.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query to create multipe total fields 7
New User - need help with a query 1
Query to Average data based on date from another table 1
summary 1
how do I find and sort unique values from a column 1
Using Unique Values and Unique Records 13
Verifying table structure... 8
Create Table / ComboBox 2

Top