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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

access query

Status
Not open for further replies.
rkelly95

rkelly95

MIS
Nov 20, 2002
27
US
I am trying to make a query in access on one table, and the primary key is a number. How can I make one record come up and not all the records
 
Sort by date Sort by votes
Sounds like you need to use DISTINCT, but...without knowing a little more about your query and the data, it's hard to tell.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

keithinoz
  • Locked
  • Question
add ip address to quick access 2
Replies
4
Views
327
keithinoz
keithinoz
lmcate
  • Locked
  • Question
Can't Access a Folder on Windows
Replies
2
Views
107
gbaughma
gbaughma
lmcate
  • Locked
  • Question
1 user lost access to a folder
Replies
3
Views
113
sysfix
sysfix
Carlvic
  • Locked
  • Question
Not authorize to access to rename,edit or delete on windows share
Replies
2
Views
70
Carlvic
Carlvic
Leozack
  • Locked
  • Question
PC losing user from remote desktop access list
Replies
2
Views
84
Leozack
Leozack

Part and Inventory Search

Sponsor

Back
Top