Unique or Distinct values from an Access Database?

V

VJG

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.
 
B

Ben Walters

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
 
V

VJG

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
 
Top