Unique or Distinct values from an Access Database?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

VJG - 19 Apr 2006 22:08 GMT

I am attempting to retrieve unique or distinct values from an Access
database. For example, I inspect 15 facilities, but these 15 facilities have
anywhere from 10 to 115 departments. Currently I setup a data connection to
an access database that works correctly, however, it pulls back duplicate
records for the facilities, where I only need to select from just the 15
facilities.

Reply to this Message

Ben Walters - 19 Apr 2006 23:31 GMT

Hey VJ
This is probablymore of a SQL or Access question but hopefully this will help
Youre select statement for your access connection should look something like
this

SELECT DISTINCT Facility
FROM dbo.FacilityTable

if you include your departments in this select statement then you will still
return duplicate records as you will return a row for each department and
facility combination

Hope this helps
Cheers
Ben Walters

> I am attempting to retrieve unique or distinct values from an Access
> database. For example, I inspect 15 facilities, but these 15 facilities have
> anywhere from 10 to 115 departments. Currently I setup a data connection to
> an access database that works correctly, however, it pulls back duplicate
> records for the facilities, where I only need to select from just the 15
> facilities.

Reply to this Message

VJG - 20 Apr 2006 17:55 GMT

Being so new to Infopath and access, where would I put this statement? Where
do I find the access connection to test the SQL statement.

Thank you - VJG

> Hey VJ
> This is probablymore of a SQL or Access question but hopefully this will help
[quoted text clipped - 18 lines]
> > records for the facilities, where I only need to select from just the 15
> > facilities.

Reply to this Message