By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,846 Members | 1,646 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,846 IT Pros & Developers. It's quick & easy.

excluding records from a query

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
ja***@utahbeef.org wrote:
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

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.
Nov 13 '05 #2

P: n/a
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

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.