showing all fields that are not blank

[smboyd]

I have a query with fields of job name, job number, bidder 1, bidder 2,
bidder 3, bidder 4. I want to be able to see the job number, name, for all
records in which fields bidder 1, bidder 2 or bidder 3 field has info
entered. Some records may have bidder 1 blank, but will have info in bidder
3.

What is the correct way to do this?

 

[Duane Hookom]

The "correct way" is to normalize your table structure so you can use
standard SQL syntax. If you don't understand how to normalize then check
this link from Jeff Conrad's site
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#DatabaseDesign101

 

[smboyd]

Gotcha. Thats what I am in the process of doing. Thanks for the website
link!!!!

 

[Dale Fye]

I'm with Duane on this regarding normalization. But, assuming you are stuck
with the structure you have, try:

SELECT [Job Name], [Job Number], [Bidder 1], [Bidder 2], [Bidder 3], [Bidder
4]
FROM yourTableName
WHERE LEN([Bidder 1] & "") > 0
OR LEN([Bidder 2] & "") > 0
OR LEN([Bidder 3] & "") > 0
OR LEN([Bidder 4] & "") > 0


HTH
Dale