Isolating Info

[How do I make it do....]

Newbie working on Access 2000 here. I am working with a mortgage broker,
trying to establish a database. I created fields to indicate if the contact
is a borrower or a co borrower. When I run a birthday report, it pulls up
all contacts not just borrower (or just co borrower). How do I run the
report to only show the contacts that have a Y (for yes) in the borrower
field only?

 

[Jeff Boyce]

How depends on what...

If you don't show us what (data/structure), we can't help with how...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.


"How do I make it do...." <How do I make it
(e-mail address removed)> wrote in message
news:[email protected]...

 

[Dorian]

You would normally run the report via a command button on a form. The form
would have a control where you would specify borrower only (possibly a
checkbox).
You would pass the value in this control to your report in the openargs
parameter.
In your report open event, you would look at the openargs value and change
the report source query appropriately (and also change the report heading
etc.).
There are other ways to do it this is just one way.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[John W. Vinson]

Newbie working on Access 2000 here. I am working with a mortgage broker,
trying to establish a database. I created fields to indicate if the contact
is a borrower or a co borrower. When I run a birthday report, it pulls up
all contacts not just borrower (or just co borrower). How do I run the
report to only show the contacts that have a Y (for yes) in the borrower
field only?

With a criterion of "Y" on the Criteria line in the appropriate field in the
contacts table. (Base the report on the query, not on the table).