Microsoft Access Question

[flyingdog]

I have a table with gift records in it. I want to create another table with the ID's of the donors. I don't want duplicates. The original table contains duplicates as it has a record for each gift.

How do I do this?

I did a create table query and tried to add just the Donor ID but I get an Invalid Argument error.

Thanks for any insight!

 

[StrawberryGal]

Oh lord, it had been a long time since I used the Access program. I haven't been using "Access" for a few years now.

I can't help you because I can't "see" to be able to show you what's wrong.

I'm thinking that you need to go in your table query to add. I'm not sure why you are getting invalid argument error. Hopefully, someone can jump in to help you.

 

[Doghnut]

Query

Probably the easiest way to get what you want is to run a make table query with the Id field and an Id Count field. The count field will collapse all of the duplicate Ids so that each Id will appear only once. After the table is made, just delete the count field.