Simultaneously Query 2 fields?

[hi there]

hi folks,

i have 2 fields [A] and and i want to only display records which have values in either [A] or . so i don't want to display records which are Null for both [A] and . but, if either [A] or contains a value i want to display the record. using a select query, i ran into the problem of Access peforming a sequential query from left to right in the QBE pane. so, it compares field [A]'s "Not is Null" and then field 's "Not is Null." if field [A]'s criteria knocks out a record that is Null for [A] but contains a value for field then i'm missing a record. i think i need Access to compare both fields at the same time. can someone help me with this or suggest a way to run this query.

many thanks everyone

 

[llkhoutx]

Put you criteria for the two fields on different rows in the QBE frame.

 

[hi there]

i tried using the "or" scenario and it didn't return the proper results.

 

[llkhoutx]

The following works:

SELECT tbTable.sA, tbTable.sB FROM tbTable WHERE (((tbTable.sA) Is Not Null)) OR (((tbTable.sB) Is Not Null));