MS Query calculated fields

[mkvassh]

I have two calculated fields in MS Query and what to make a third calculated field based on the other two. Is that possible and if yes do you have an example.

I ask this question because I can't see my calculated fields in the drop-downs list and has not been able to refer to these fields manually yet.

[Cheeky Charlie]

For anything remotely complex MS Query is woefully inadequate - I build queries in Access then refer to the query, not the table, in data imports.

CC