By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,454 Members | 2,633 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,454 IT Pros & Developers. It's quick & easy.

Query that returns unique records, except for adding one feild.

P: 2
I'm very new at Access, so if this is a lame question I'm sorry.

Anyways, I'm trying to make a query that returns unique entries from a table, but when it finds two entries where everything matches except for in this case the feild "Ammount" it returns the entry unique but adds the differing ammount entries.

Bassically I'm trying to get the sum of ammounts for entries that are otherwise duplicates.
Feb 8 '08 #1
Share this Question
Share on Google+
1 Reply


P: 2
I'm very new at Access, so if this is a lame question I'm sorry.

Anyways, I'm trying to make a query that returns unique entries from a table, but when it finds two entries where everything matches except for in this case the feild "Ammount" it returns the entry unique but adds the differing ammount entries.

Bassically I'm trying to get the sum of ammounts for entries that are otherwise duplicates.

Figured it out, I feel pretty daft now. Thanks anyways.
Feb 8 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.