Sorting ranges of revenue and ranges of employees

[Guest]

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

 

[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

 

[Guest]

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

Best regards, Larry

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-
--

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