Search for an EXACT numeric value on form

[birbjo]

Hi!
I have a database with several fields. One of these fields holds a numeric value, “amounts”.
I want to create a search form in Access that gives the user a possibility to search for amounts, as well as for some of the other fields, If several different search-values are needed.
There’s no problem to search for the other fields on the form. Here I just am using the following query-specification:

Like “*”& [forms]!(formName]![text93] & “*”

...this gives “**” if no values has been chosen on the form, or “*value*” if a value HAS been chosen on the form.
HOWEVER….
When I use this on the AMOUNT-field this gives an INCORRECT result….or at least, not the result I want.
If I, for example, enter the amount “500” in the amount-field on the form, this gives a reply of *500*, thus resulting in a search for ANY value that has the numbers 500 in them….like “28.500” or 425.006……


How can I specify the query to

1. Let the user leave the amount-search-field BLANK on the search-form, thus looking for ALL amount-values or
2. Let the user specify a specific number/amount, thus searching for EXACTLY that amount, and NOT any amount containing that number…?

I can’t find any solution to this problem by googling…..

Best regards
Björn

[pbaldy]

How about

http://access.mvps.org/access/queries/qry0001.htm

[birbjo]

Worked like magic.......! My weekend is saved! You are my new hero!
(But wasn't it almost to simple.... :-) ? )
THX and a VERy GOOD weekend to You!
Björn

[pbaldy]

LOL! Happy to help, and welcome to the site by the way.