I have a query that returns a percentage in one column. I have an open form with a text box that has a format set to percent and for some reason when I set the query criteria to point to the open form field using a >= it just ignores it.
The criteria I am trying to use is as follows.
>=[Forms]![Start Page]![text377]
Unfortunetly my query results return full records as if EVERYTHING matched that criteria.
The form field I set a value of 75 to test it but I am getting records back that read everything from 0% to 100%
Anyone have a pointer?
The criteria I am trying to use is as follows.
>=[Forms]![Start Page]![text377]
Unfortunetly my query results return full records as if EVERYTHING matched that criteria.
The form field I set a value of 75 to test it but I am getting records back that read everything from 0% to 100%
Anyone have a pointer?