excluding records from a query

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

re: excluding records from a query

jacob@utahbeef.org wrote:[color=blue]
> 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
>[/color]
I usually present the data to a user in a form. So my form may have a
recordsource like "Select * From Members". This will present a list of
all records from members. I may have a combo box at the top called
"Funds" with a list of all funds and an option for All Funds. In the
after update event I may have code like
'create the filter
If Me.ComboFunds <> "All Funds" Then
Me.Filter = "Funds = '" & Me.ComboFunds & "'"
Endif
'turn the filter on or off
Me.FilterOn = (Me.ComboFunds <> "All Funds")

Look at the Filter property in help if you want to execute filters on a
query.

re: excluding records from a query

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


<jacob@utahbeef.org> schreef in bericht news:1113854849.256959.72990@f14g2000cwb.googlegro ups.com...[color=blue]
>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
>[/color]