Jacob,
I do have some ideas ... but your question is a little vague (to me)
I will try:
You have a query with members that have renewed (payed) for the month and also the funds ?
Now you want a report for the members that payed for a particular fund ?
If so, all you need is another criterion in your query.
In your query-design-grid, in the 'column' where it says "Fund" add the particular fund in the criterion line.
Or: Open the report based on your query but with a where-clause like:
DoCmd.OpenReport "ReportName", , , "Fund = 12"
--
Hope this helps
Arno R
<ja***@utahbeef.org> schreef in bericht news:11*********************@f14g2000cwb.googlegro ups.com...
I am using a membership database and trying to exclude certain records
that have not paid dues for that particluar fund. I have a query that
will pull up all members that have renewed for the month and the funds
that they have paid. When I run a report, I only want to include those
that have paid for a particular fund. What do I put in the query to
exclude those that have not paid? I thought putting something like
"include if it is >1" or something similar would work.
Does anyone have some ideas?
Thanks,
Jacob