Using Unbound Data as criteria for amount search 1

[Stoffman]

I have massive list of Debit and Credit transactions (+ and -) . I am trying to use an unbound control in a form as the criteria. However I need to be able to search for records which are 'Less than and equal to' or 'more than and equal to' or if this control is left blank to display all records.

I cannot use <= or >= in the form control as it a numeric field.

I also cannot use

Like '*' & [Forms]![FRM: User Defined Query]![Transaction amount] & '*' in the queries criteria, as I cannot preceed this with <= or >= as it just keeps moaning at me.

Any help would be great as I am having one of those days

 

[PHV]

Something like this ?
WHERE (Abs([your Debit Credit field])>=[Forms]![FRM: User Defined Query]![Transaction amount] OR [Forms]![FRM: User Defined Query]![Transaction amount] Is Null)

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

 

[Stoffman]

Thats great thanks alot