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

do not repeat a field on a query?

Status
Not open for further replies.
Gustavson

Gustavson

Technical User
Nov 2, 2001
105
US
I'm using access97. I have a query on which there is a field called building. this information is being retrieved from another query.. I don't want buildings to repeat so for example, lets say Onyx Brige is in the Query. I only want it displayed once.. even though it may be displayed several times in the other query.. Should I add some kind of criteria which only allows a name to be displayed once?

Hope this makes sense..
Thanx Gustavson
 
Sort by date Sort by votes
okay, i just use ths Sum function and Group by...
Thanx
Gustavson
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BallunarCrew
  • Question
ODBC Driver Struggles on new computers
Replies
2
Views
527
BallunarCrew
BallunarCrew
TheresAlwaysAWay
  • Locked
  • Question
Crazy question: Can anyone help me create a routine to roll 2 dice 1000x and sum them? 4
2
Replies
22
Views
6K
Andrzejek
Andrzejek
lameid
  • Locked
  • Question
Execution Slowing on iterative generation of PDF's
Replies
3
Views
811
lameid
lameid
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
renigar
  • Locked
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
965
renigar
renigar

Part and Inventory Search

Sponsor

Back
Top