SQL Script for Destinct ID

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to Select DeskNumber from TableA for a search Field. However
DeskNumber while indexed allows duplicates. I only want to show Each Desk
Number once even If it should occur 5 or 6 times. I have tried several
variations of the Destinct command but apparently I either don't remember its
correct use or Access doesn't recognize it at it always gives me a missing
operator error when I do this. Please Help

Thanks,
Kalor
 
Well, you gotta spell it right for one thing....

"SELECT DISTINCT ....."
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

New HP Printer (OfficeJet 5610) - No Destinctive Ring Feature for Fax? 1
MPV - versitile fast lean player. 3
SQL to recreate database structure 6
Move my Access-Database to SQL-Server 3
SQL Server and Access 2007 1
Writing user friendly error message in Access for specific SQL Server table error 1
loading tables via SQL script 5
Should I break down this kind of Table? >.< 1

Back
Top