specific query to sort info

J

Jae Hood

Hi,
I have a table with order details which includes a status field.
I'm wondering how to create a query which i assume would be made into a form
for my end-users which allows them to see all orders under a current status
(ie. open, shipping, delivered, closed)

Thank you!
 
K

KARL DEWEY

Use the following criteria for STATUS --
"Open"
- OR -
"Shipping"
- OR -
any of your statuses.
 
J

Jae Hood

Not sure what property i'm editing.
In my shipment details table, theres a lookup for the status field
"open;shipping;delivered;closed".
Now on my form I thought I would either have to use a query, or some type of
combo box that allows to me select one of those lookup values and output all
orders with that specified status.

Thanks for the help!
 
K

KARL DEWEY

Build a query with criteria from a form you build a with a ListBox. Fill
with status. Row source for form is the query.
Criteria --
[Forms]![YourForm]![YourListBox]
 
J

Jae Hood

Build a query with criteria from a form that i build with a listbox?

Sorry, I just don't get it.

KARL DEWEY said:
Build a query with criteria from a form you build a with a ListBox. Fill
with status. Row source for form is the query.
Criteria --
[Forms]![YourForm]![YourListBox]

Jae Hood said:
Not sure what property i'm editing.
In my shipment details table, theres a lookup for the status field
"open;shipping;delivered;closed".
Now on my form I thought I would either have to use a query, or some type of
combo box that allows to me select one of those lookup values and output all
orders with that specified status.

Thanks for the help!
Click to expand...
Click to expand...
 
Top