Limit query to span of id #s

  • Thread starter Thread starter Mary Hartman
  • Start date Start date
M

Mary Hartman

I have created a database in which the inventory_id is an auto number.

I would like to create a query that would select on a small range of
them.

For example: I would like to get #s 1 - 90 and in the next query #s
90 - 150.

Can someone help with this?
 
Create a new query. Open it in design mode. Add the table containing the
Inventory_ID. Add the Inventory_ID field. Add any other fields you'd like
to see.

Under the Inventory_ID field, in the row for selection criteria, put:

Between [Enter starting number] And [Enter ending number]

By the way, Access Autonumbers are NOT guaranteed to be sequential. If you
are using this field to "count" the number of records, sooner or later
you'll get burned.

If you need a count, use a Totals query.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I have created a database in which the inventory_id is an auto number.

I would like to create a query that would select on a small range of
them.

For example: I would like to get #s 1 - 90 and in the next query #s
90 - 150.

Can someone help with this?
Click to expand...

As criteria on the [Inventory_ID] column, write:

Between [Start At] and [End With]

You will be prompted for the beginning and ending numbers when the
query is run.
 
Back
Top