Form textbox (percent) as query criteria? (1 Viewer)

Tango

DB/Application Dev Newbie
Local time
Today, 18:19
Joined
Jun 23, 2011
Messages
141
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?
 

Tango

DB/Application Dev Newbie
Local time
Today, 18:19
Joined
Jun 23, 2011
Messages
141
Ok, I solved it myself. I had to keep the data type for both fields as a "Fixed" data type. I converted it to a percentage in a 2nd query after the filter operation was complete.
 

Users who are viewing this thread

Top Bottom