 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / May 2008Parameter searching all like numbers
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. Abs([YourField]) remove the sign.  SignatureKARL DEWEY Build a little - Test a little > 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]) > Abs([YourField]) remove the sign. > [quoted text clipped - 3 lines] > > So I want to be able to enter "18.50" once and it return all like numbers. > > How do I do this. 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. > [quoted text clipped - 10 lines] >>> So I want to be able to enter "18.50" once and it return all like numbers. >>> How do I do this. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.