gsgriffin
Technical User
- Oct 17, 2002
- 27
I'm stumped.
I'm using a text box on an Access form to present the results of a query built into its properties. The box is set up as a drop down list, but the only value showing to select from is the result from the internal query. The query is designed to only have the sum of values as the result. Therefore, one column, one row, one result is showing.
I would like to compare the value that I can view in this box with another known value. When I try to compare the values, the value of my field --Me![Confirmed]--is always Null. I can see the value presented in the box, but it is more or less only a value from a pick-list and not an entered value.
How can I get that value which is Column 1, Row 1 of a query for comparison? Should I go about it in another way?
Thanks
I'm using a text box on an Access form to present the results of a query built into its properties. The box is set up as a drop down list, but the only value showing to select from is the result from the internal query. The query is designed to only have the sum of values as the result. Therefore, one column, one row, one result is showing.
I would like to compare the value that I can view in this box with another known value. When I try to compare the values, the value of my field --Me![Confirmed]--is always Null. I can see the value presented in the box, but it is more or less only a value from a pick-list and not an entered value.
How can I get that value which is Column 1, Row 1 of a query for comparison? Should I go about it in another way?
Thanks
