Setting a text search to Currency

[Krash878]

I use a form that looks to a query.

The query has a criteria of currency for a txt box that resides on the form.

The criteria is

Like "*" & [forms]![frmArchiveChargeBack]![txtSearch] & "*"

Can I make it convert the text to currency here?

Krash

 

[KenReay]

Hi

This is not going to work.

You can convert to Currency using CCUR(), but you are using the LIKE operator which is a string operator which accepts wild cards like "*" and "?"

Hope this helps

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove SPAMNOT to use

 

[Krash878]

I can take out the wildecards for this.

Like [forms]![frmArchiveChargeBack]![txtSearch]

where would the ccur go?

Krash

 

[KenReay]

HI

no point using LIKE under these circumstances:

= CCur([forms]![frmArchiveChargeBack]![txtSearch])



Hope this helps

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove SPAMNOT to use

 

[Krash878]

Yes,
It works.

I set it up after I posted last. I used Like though I will try it with the "=" instead.

Thanks
Krash