ntsabman
asked on
Access 2010 Query
i have a table that i want a query to give me record number of each recard that have on of 5 field as empty or 0 rigth now i did this and get only the one that all are empty
Field1 field2 field3 field4 field4
null or 0 null or 0 null or 0 null or 0 null or 0
but if let say record 3 has field3 with 3 in it and the other field null it dont so up in the report
testdb.zip
Field1 field2 field3 field4 field4
null or 0 null or 0 null or 0 null or 0 null or 0
but if let say record 3 has field3 with 3 in it and the other field null it dont so up in the report
testdb.zip
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.