Hi all!
I know this is simple but I cannot make it to give me the result I need.
Say I have a table like this:
How do I make the query not to include record 4 with all 0's in fields Number1, Number2, Number3 and Number4?
I tried this:
but it gives me no record.
Appreciate the help!
I know this is simple but I cannot make it to give me the result I need.
Say I have a table like this:
How do I make the query not to include record 4 with all 0's in fields Number1, Number2, Number3 and Number4?
I tried this:
Code:
SELECT tblTemp.ID
FROM tblTemp
WHERE (((tblTemp.Number1)<>0) AND ((tblTemp.Number2)<>0) AND ((tblTemp.Number3)<>0) AND ((tblTemp.Number4)<>0));
Appreciate the help!