Access 2002: query 2 fields in same table -> "true" value if both.

M

Marvin

Pretty new at Access.

I want to query two fields in the same table and get Access to return a
value of "false" if either field contains no data, otherwise, I want it to
return a value of "true".

Ideally, I want to be able to create a report from the query that lists each
record with the results of this true/false test.

Any suggestions on how to do this?
 
V

Van T. Dinh

Try a query with the SQL String like:

SELECT Table1.*, IIF(IsNull(Field1) Or IsNull(Field2), False, True) AS
Has2Values
FROM Table1

Check Access Help / Access VB Help on the IFF() and the IsNull() function.

HTH
Van T. Dinh
MVP (Access)
 
Top