Creating a Query with a numberical range

  • Thread starter Thread starter AMG Leads
  • Start date Start date
A

AMG Leads

I am a novice with Access and need help performing a query from a specific
field. For example I would like to take large database and reduce the data
based upon a specific income level say between 18000 and 55000. How would I
format the query field to limit its search to this range?
 
Your question doesn't make sense. Fields in tables are targets of
queries. There is no such thing as "performing a query from a field.
You can store the text of a query in a field but I think you' have
mixed terminology somewhere along the line. You can't execute a query
from a field.

If you are confusing Access with Excel because some parts look the
same, be aware that Access doesn't store formulas in "cells". I don't
think Access even uses the term "cell".

You can look in Access Help for "query". There are lots of
informative choices.

You can post back explaining in detail and in terms of the real world,
the results you hope to obtain.

HTH
 
If you want to apply criteria against the data in the field in a query.

Field:Income
Criteria: Between 18000 and 55000

That will return records where the income field contains a value between
18000 and 55000 (inclusive). That does assume that the Income field is a
number field and not a text field that contains number characters.

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