Query Criteria set by Form Text Box

[jennilein]

I've used drop down lists in forms to set criteria for queries and text boxes too - however - in this one case it's not working.

Normally, I have a set value or use "*" to run the query. This time I would like the text box for entering "*" or a >=0 statement. It works with the "*" - but it doesn't seem to like the ">=". Is it possible to use a text box on a form to enter these types of query criteria??

Thanks a bunch!

 

[SkipVought]

Hi,

How are you USING the textbox WITH your query criteria? Post your code.

Skip,

_{[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large!}

 

[PHV]

How and where is your criteria built/retrieved ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[jennilein]

I'm using a form to set the criteria in a query which opens a report.

I've tried these two options:
Like [Forms]![frm_impactsim]![txt_negnetqty] & "*"

and
[Forms]![frm_impactsim]![txt_negnetqty]

There are really only two criteria options * or >=0

does this help clarify?

 

[PHV]

Some inconsistency here: Like * is for text, >=0 is for numeric.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[jennilein]

The field is numeric - containing both negative and positive numbers. I would like to use the text box to set criteria to include either all records or only those with a positive quantity.

Do you have any suggestions? Is this possible to do with a text box?

 

[SkipVought]

the LIKE operator goea AFTER the fieldname
[tt]
[Forms]![frm_impactsim]![txt_negnetqty] & " Like " & "A*"
[Forms]![frm_impactsim]![txt_negnetqty] & " >= '" & "somevalue" & "'"
[/tt]
usually these are in a textbox
[tt]
[Forms]![frm_impactsim]![txt_negnetqty] & " Like " & textbox1.text
[/tt]
where textbox1.text = "A*"

Skip,

_{[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large!}

 

[PHV]

something like this ?
WHERE ... ([Forms]![frm_impactsim]![txt_negnetqty]="*" OR [field name]>=0) ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244