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

duplicates

P: n/a
How do I query a db that has multiple entries with the same name but additional
info, so that I can pull mthat name only once?

example Date; ID; Name; Amount; Sate;
7/5/02; 99; Druids; $500; VA
9/7/03; 99; Druids; $150; VA

The name might appear many times,from 7/5/02 to 9/7/03, but I just want it
once.
in the output record

Kind regards

Leonard Oostra
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
If your output just contains the name field then you set the 'Unique
values' property for the query.

Right-click on the grey query background (or click the Properties
toolbar button) to access the properties.

If you need other info as well as the name then you must define how to
select that data when you find duplicate names.

Regards

Peter Russell

GRAAG previously wrote:
How do I query a db that has multiple entries with the same name but
additional
info, so that I can pull mthat name only once?

example Date; ID; Name; Amount; Sate;
7/5/02; 99; Druids; $500; VA
9/7/03; 99; Druids; $150; VA

The name might appear many times,from 7/5/02 to 9/7/03, but I just want
it
once.
in the output record

Kind regards

Leonard Oostra


Nov 12 '05 #2

P: n/a
Use a Totals query, "Group By" the duplicate fields, use "Sum" or "Max" or
"First" on the non duplicate fields

"GRAAG" <gr***@aol.com> wrote in message
news:20***************************@mb-m16.aol.com...
How do I query a db that has multiple entries with the same name but additional info, so that I can pull mthat name only once?

example Date; ID; Name; Amount; Sate;
7/5/02; 99; Druids; $500; VA
9/7/03; 99; Druids; $150; VA

The name might appear many times,from 7/5/02 to 9/7/03, but I just want it
once.
in the output record

Kind regards

Leonard Oostra

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.