Parameter searching all like numbers

  • Thread starter Thread starter Kay
  • Start date Start date
K

Kay

I have a query that holds any where from 1200 to 4500 records at a time that
I use to balance our accounts. What I need is an expression/parameter that
will search like numbers. For Example. I want to group -18.50 and 18.50.
So I want to be able to enter "18.50" once and it return all like numbers.
How do I do this.
 
Thank you so very much, that saved me hours of balancing that schedule.



I ended up using the following criteria.

criteria: Like "-" & Abs([Amount])
or: Abs([Amount])


KARL DEWEY said:
Abs([YourField]) remove the sign.
--
KARL DEWEY
Build a little - Test a little


Kay said:
I have a query that holds any where from 1200 to 4500 records at a time that
I use to balance our accounts. What I need is an expression/parameter that
will search like numbers. For Example. I want to group -18.50 and 18.50.
So I want to be able to enter "18.50" once and it return all like numbers.
How do I do this.
Click to expand...
Click to expand...
 
I think Karl meant

Field: Abs(YourField)
Criteria: Abs([Your Search Value])


Or you could do
Field: YourField
Criteria: [Your Search Value]
Criteria: [Your Search Value] * -1

The latter will be the most efficient, especially if YourField is
indexed. With small recordsets you might see no real difference in
performance.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

Thank you so very much, that saved me hours of balancing that schedule.



I ended up using the following criteria.

criteria: Like "-" & Abs([Amount])
or: Abs([Amount])


KARL DEWEY said:
Abs([YourField]) remove the sign.
--
KARL DEWEY
Build a little - Test a little


Kay said:
I have a query that holds any where from 1200 to 4500 records at a time that
I use to balance our accounts. What I need is an expression/parameter that
will search like numbers. For Example. I want to group -18.50 and 18.50.
So I want to be able to enter "18.50" once and it return all like numbers.
How do I do this.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top