Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Select distinct 1

Status
Not open for further replies.
blizkij

blizkij

Technical User
Oct 11, 2001
22
AU
Hi,

I have a query that works fine, however I was wondering can you use select distinct in Access SQL?

thanks in advance
 
Sort by date Sort by votes
In Access if you type Help then enter Distinct you get the complete answer to this. I wonder why you didn't do that. mike.stephens@bnpparibas.com
 
Upvote 0 Downvote
I did look in help and it only referred me to a visual basic module. I was actually wanting to use it in an SQL statement.
 
Upvote 0 Downvote
You can add the word distinct in the SQL view of your query. This removes duplicates of the fields mentioned. Distinctrow removes duplicate records ie where all fields in the recordset have identical values.

Which reminds me I seem to remember the QBE screen used to put distinctrow in by default didn't it? mike.stephens@bnpparibas.com
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Swi
  • Locked
  • Question
Jet Sql Statement - Select Distinct Multiple Columns 1
Replies
4
Views
276
Swi
Swi
lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
334
lameid
lameid
monkeysee
  • Locked
  • Question
Select Query for append query 1
Replies
12
Views
230
monkeysee
monkeysee
TrekBiker
  • Locked
  • Question
Select addresses using two criteria, one 'Like" 2
Replies
3
Views
130
TrekBiker
TrekBiker
Moss100
  • Locked
  • Question
Distinct query makes combined query none updatable 1
Replies
8
Views
149
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top