Query issue (where cell populated aswell as any of the other listed ce

[chrisjohns]

Hi,

I have a query im wanting to run on a table but i cant get the syntax to work with it.

Im trying to get it to display records where "DateJoined" is populated, and any of the other cells listed in the query are populated (be that 1, 5 or all).

E.g Date ="01/01/01"

Name = ""
Surname = ""
MaidenName = "Johns"

So it will pick this up because it has MaidenName populated.

 

[dhookom]

I am having trouble picturing a table with that might contain all empty "fields" (not cells). Your WHERE clause in the query might look something like:

WHERE  [DateJoined] Is Not Null AND Len([FieldA] & [FieldB] & [FieldC] & [FieldD] & [FieldE] & "") > 0

Duane
Hook'D on Access
MS Access MVP