Sorting ranges of revenue and ranges of employees

L

Larry

I am having no luck at all trying to successfully sort in descending order
ranges of revenue s/a "$500,000-$1,000,000" or employee ranges s/a "1 to 50"
or "1-50." Either the ranges turn into dates (with employee ranges) or both
revenue and employee range columns don't sort in true descending order at all
(where, say, $500,000-$1,000,000 would automatically be above
$50,000-$60,000).

There's probably an easy way to do this, but I've not yet blundered onto it.
FYI, my usual database experiences are with Mac's Filemaker, which seems to
be a lot more user friendly.

Thanks much, Larry
 
L

Larry Daugherty

If you're using the query by example wizard, enter ranges in the
criteria line using the keyword BETWEEN. Between [Enter start date]
and [Enter end date] will return all dates between and inclusive of
the start date and end date. The same scheme works for salary ranges.

HTH
 
L

Larry

Thanks much! Just installed Access the other day and OBVIOUSLY didn't finish
the tutorials.

Best regards, Larry

Larry Daugherty said:
If you're using the query by example wizard, enter ranges in the
criteria line using the keyword BETWEEN. Between [Enter start date]
and [Enter end date] will return all dates between and inclusive of
the start date and end date. The same scheme works for salary ranges.

HTH
--
-Larry-
--

Larry said:
I am having no luck at all trying to successfully sort in descending order
ranges of revenue s/a "$500,000-$1,000,000" or employee ranges s/a "1 to 50"
or "1-50." Either the ranges turn into dates (with employee ranges) or both
revenue and employee range columns don't sort in true descending order at all
(where, say, $500,000-$1,000,000 would automatically be above
$50,000-$60,000).

There's probably an easy way to do this, but I've not yet blundered onto it.
FYI, my usual database experiences are with Mac's Filemaker, which seems to
be a lot more user friendly.

Thanks much, Larry
Click to expand...
Click to expand...
 
Top