Calculated fields in forms only exit in the form. You cannot query a calculated field from a form. You can regenerate the calculations in a query based on the same table the form is base on.
Chester
I have a field on a form which is calculated (A minus B). It displays properly on the form with the correct answer. I can't figure out how to get it to pull into a query? My query is pulling any record with that field criteria >0 and no records come up when I run the query altough there should be several with a positive result in the field.
I am a newbie, so please bear with me . . . . thanks in advance for any help.
Reputation Points: 10
Solved Threads: 0
Junior Poster in Training
Offline 65 posts
since Mar 2005
Unsolved 
