C
CMegrey
Hello all,
I know this may be a stupid question but i'm a newbie to Access. Here
the background on what I'm designing.
I'm creating a database to track special orders for our store
customers. Employees enter information about the order including
customers name, contact information, item to be ordered and etc. The
main form has multiple check box to note if the customer has paid, the
order has been placed, arrived, when the customer was notified and
when the customer picks up the item. I'm looking to create a query
that checks the field to see if a specific check box is checked and
then display it in a report. For example I would like access to query
the table for all records where the order placed checkbox is not
checked and then display those rows in a report with the customer and
item requested. I would like to do the same for reports to display
when order placed is checked but order arrived is not and so on and so
forth. I have some basic experience with VB but I'm not sure how to
get access to do this. Again I apologize if this is a stupid question
but any help is appriciated.
Thanks,
Chris
I know this may be a stupid question but i'm a newbie to Access. Here
the background on what I'm designing.
I'm creating a database to track special orders for our store
customers. Employees enter information about the order including
customers name, contact information, item to be ordered and etc. The
main form has multiple check box to note if the customer has paid, the
order has been placed, arrived, when the customer was notified and
when the customer picks up the item. I'm looking to create a query
that checks the field to see if a specific check box is checked and
then display it in a report. For example I would like access to query
the table for all records where the order placed checkbox is not
checked and then display those rows in a report with the customer and
item requested. I would like to do the same for reports to display
when order placed is checked but order arrived is not and so on and so
forth. I have some basic experience with VB but I'm not sure how to
get access to do this. Again I apologize if this is a stupid question
but any help is appriciated.
Thanks,
Chris