Using Derived Column in Where Condition

[anunat]

I am making queries using VBA in Access.
I have one query temp3 that returns several records with columns ID, Diff etc.
I would like to filter the results of temp3 further using the condition temp3.[Diff] <> 0
I could not use this condition within temp3 because Diff is a derived column.
So I making another query temp4 as below:
SELECT * FROM temp3
WHERE temp3.[Diff] <> 0;
When I run this Query, the records filter correctly. However, the Diff column is blank for all records.


What am I doing wrong here?
I also tried nesting temp 3 as below and get the same issue:
select * from( Query temp3) as data where data.diff <> 0
Can you please help me with this?

[help_me_with_access]

perhaps the DIFF column is a different data type in the output of temp3?

did you open it and look at it directly through the GUI??? what's the sql of temp3? are you sure the are actual values in the DIFF column for the 1st query too? maybe temp4 is right, but you're not checking what you're supposed to be checking and the error is in temp3 instead, or in the data???

i think the alignment of the values also comes through directly in queries. so for instance, left is text, right is numeric vals. check that too, obviously.