Simple Access Query/Form Question

  • Thread starter Thread starter CMegrey
  • Start date Start date
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
 
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
Click to expand...

HI Chris,

I would recommend creating a textbox on your report with logic such
as:

=IIf([flgProcessed]=True,"OH YEAH","No")

(where flgProcessed is the field you're interested in and the
subsequent fields are the yes/no results). Make sure your textbox has
a different name to the underlying field. This should work reasonably
well but if you have any questions, please provide more details.

Hope this helps,
James
 
Back
Top