How can I use criteria with an expression?

[crobaseball]

So I have a calculated field in a query creating a table, and I don't want any records where the calculated field = 0. So I set the criteria to >0 . . .

Here's a screenshot of my query: http://www.pixentral.com/show.php?pi...EjkyxRzUybETIF



But when I go to run it, it asks for a value for
[List]. When I run it without the criteria, it creates the table without asking for a value for
[List].

Thoughts? Thanks!

[crobaseball]

Well, I googled this a slightly diff way, and the answer I saw says I can't actually do this. I can't refer to another calculated field and have criteria. So I copied and pasted the other calculated field over. This is really strange to me. I'm surprised Access/SQL doesn't allow you to essentially create a variable to use. It makes for some long expressions