MS Access Query Criteria Issue

Posted by xxl3ww on Super User See other posts from Super User or by xxl3ww
Published on 2011-03-17T15:46:44Z Indexed on 2011/03/17 16:12 UTC
Read the original article Hit count: 243

Filed under:

Currently I have a MS Access database query that has a field named FedEXDetTotal that totals 9 FedEX charge fields. I have another field that is from our inhouse system called "Total Charge". This is just a normal number field. I have created another Field in this query

Diff: [FedEXDetTotal]-[Total Charge]

This tells me the difference between the Fedex charge and what we actually charged. Everything works OK with this, but when I try to put the criteria >5 for the Diff field, when I run the query, I get a prompt saying "Enter Parameter Value FedEXDetTotal".

Why is Access doing this? How do I get around this? I'm trying to start out with something simple(>5), but what I really want is >[Forms]![Dis].[txtbox_Diff].

© Super User or respective owner

Related posts about microsoft-access