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

Peronnel Area Reporting Database

P: n/a
HI All, I'm a nubie to access but have been asked to put together a
database none the less!

I have had to create a report that shows: Company, Area, employees
skill set, and Employee Name. I have done this OK, but am having a
couple of troubles with:

Getting combobox's to show (in the entry form) without duplicate
entries within them. ie if more than one employee works in a given
area, this area will apprear more than once in the combobox.
And; checking for, and removing duplicate entries in the database.

Any Help would be greatly appreciated!

Thanks
A

Feb 27 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
<ag********@gmail.com> wrote
Getting combobox's to show (in the entry form)
without duplicate entries within them. ie if more
than one employee works in a given area, this
area will apprear more than once in the combobox.
In design view of the form, right-click that Combo Box, choose Properties,
click the Data tab, and open the Row Source in design view -- even if what
shows is SQL, it should open the Query Builder. In the Query builder, in the
upper part, but not on one of the data sources, right click and open its
Properties... experiment with Unique Values and/or Unique Records. The
resulting SQL should read "SELECT DISTINCT... ".
And; checking for, and removing duplicate entries
in the database.


I believe one of the Query wizards is for finding duplicates. Assuming they
are not duplicates in every column, you'll probably need to examine them
manually to determine which ones to keep and which to discard.

Larry Linson
Microsoft Access MVP


Feb 27 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.