Peronnel Area Reporting Database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

aglenister@gmail.com - 27 Feb 2006 02:39 GMT

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

Reply to this Message

Larry Linson - 27 Feb 2006 03:56 GMT

> 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

Reply to this Message