Form textbox (percent) as query criteria?
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.
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?
If I helped you, please click thanks or the balance scales on my post.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.