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

DISTINCT in 4 columns displayed

Status
Not open for further replies.
callcentreman

callcentreman

Technical User
Sep 7, 2001
10
NL
Hi can anybody help me with this? I need to run a query to get a distinct value that can be in either 1, 2, 3 or all of 4 columns in one table. Can I get them listed in 1 combo box?

thanks a mil for any help
[glasses]
Callcentreman
 
Status
Not open for further replies.

Similar threads

renigar
  • Locked
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
947
renigar
renigar
Bubba002
  • Locked
  • Question
WHERE clause in the Set command of an db.OpenRecordset method
Replies
16
Views
1K
dhookom
dhookom
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
Trob70
  • Locked
  • Question
There is no object in this control 1
Replies
9
Views
868
Trob70
Trob70
atadbitslow
  • Locked
  • Question
how to search data and display matches that include the user's input, but not necessarily match
Replies
5
Views
605
atadbitslow
atadbitslow

Part and Inventory Search

Sponsor

Back
Top