Iff Statement with Format()

[Lynn_AccessUser]

I have the following query:

SELECT Format(CVar([Table1.F1]),"000000") AS TextNumber
FROM Table2 RIGHT JOIN Table1 ON Table2.F1 = Table1.F1
WHERE (((Format(CVar([Table1.F1]),"000000")) Is Not Null) AND ((Table2.F1) Is Null))
ORDER BY Format(CVar([Table2.F1]),"000000");

There are 2 problems.

1. I return 2 empty records. Before I formatted the field, null values were not returned.

2. It finds 10:0 in the table and returns 000000

Is there a way to write a Iff statement that if Table1.F1 = 10:0 do not return (show) in the query and prevent empty records from showing.

Thanks!