Can this be done???

  • Thread starter Thread starter tcek
  • Start date Start date
T

tcek

A simple "yes" or "no" will suffice. How to accomplish this will come later.
I would like to run a query that identifies certain customers. Once
presented the query result list of customers, I would like to "select" only
certain ones (after reviewing the list) either by check box or other methods
(other than amending original query criteria). Once I select the desired
customers, perform a subsequent query (sub-query??) or report print a form
letter.

Sounds complex and just might be but this approach would save a huge amount
of time in our daily activities.

An example would be to identify those customers that are 30 days overdue in
payment. However, if a customer is 31 days overdue and has been a good prior
customer, I may not desire to send out a notice. This would be based on my
discretion and not any particular criteria
 
Yes. Your query will be the basis of a form, and you can put a button,
checkbox, etc. on that form, which will show up for each record returned
on the underlying query. That button drives a "print/noprint" field,
which is then used for the subsequent query.

It will actually going to be fairly straightforward.
 
A simple "yes" or "no" will suffice. How to accomplish this will come later.
I would like to run a query that identifies certain customers. Once
presented the query result list of customers, I would like to "select" only
certain ones (after reviewing the list) either by check box or other methods
(other than amending original query criteria). Once I select the desired
customers, perform a subsequent query (sub-query??) or report print a form
letter.
Click to expand...

Yes. You will need a Yes/No field in the customer Table to do so.
 
Back
Top