Can this be done???

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
 
P

Phil Smith

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.
 
J

John W. Vinson

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.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top