Query from POP-up box

[Thompyt]

I can get the pop-up box query to run fine, but I have a question on how to set a range in the pop-up. The format is ###.## ie: 300.00, but I would like to include anything under the 300.## (330.01, 300.02 to 300.99)



How is this done? I have tried $$, **, ## as wildcards.

Thanks

[June7]

Wildcards are for text fields, not number or date.

You can use logical operators: <, >, <=, =>, =, <>, BETWEEN [value1] AND [value2]

[Thompyt]

I used some other fields in the Table to brewak it down to where i could see the required data without using a pop-up.