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

query - display data only once?

Status
Not open for further replies.
Gustavson

Gustavson

Technical User
Nov 2, 2001
105
US
I'm using access 97. How do I display data only once in a query? Can I add something to criteria to only allow data to be displayed once.
For example:
red
green
blue

Not:
red
red
red
green
green
blue

Hope this enough info..
Thanx
Gustavson
 
Sort by date Sort by votes
open the query in design view, place the cursor in the area where the tables are displayed, and left-click the mouse to display the Query Properties, change the Value for Unique Values from No to Yes.

PaulF
 
Upvote 0 Downvote
Not having seen the query you are starting from my first question is are you fimilar with grouping clauses.

Please post a copy of the SQL and I'll take a look to see what I can see.

ssecca
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

atadbitslow
  • Locked
  • Question
how to search data and display matches that include the user's input, but not necessarily match
Replies
5
Views
599
atadbitslow
atadbitslow
MikeRei
  • Locked
  • Question
Help taking horizontal data and displaying it vertically (continuously)
2
Replies
27
Views
2K
dhookom
dhookom
PizMac
  • Locked
  • Question
error 3027 database or object is read-only
Replies
5
Views
703
PizMac
PizMac
TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
5K
TheresAlwaysAWay
TheresAlwaysAWay
ameedoo3000
  • Locked
  • Question
switch between two open database
Replies
12
Views
1K
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top