changing labels criteria

[BagelAnne]

I have a rather large membership database and I have a
report that prints labels from the membership table.
Is there an easy way for me to change the parameters of
the report on the fly to print only specific records?
I want to option to sometimes print lables of only those
members who renewed in 2004 (A field in the members table).

 

[Duane Hookom]

Your report should be based on a query. You can search help for information
on creating queries and setting criteria. Allen Browne has some basics on
his web site http://members.iinet.net.au/~allenbrowne/tips.html

 

[fredg]

I have a rather large membership database and I have a
report that prints labels from the membership table.
Is there an easy way for me to change the parameters of
the report on the fly to print only specific records?
I want to option to sometimes print lables of only those
members who renewed in 2004 (A field in the members table).

Simplest way is to create query to be used as the recordsource for the
label report.

To answer your immediate question, add another column to the query
RenewedYear:Year([DateRenewed])

as criteria for the [RenewedYear] column, write:
2004

A more useful solution would be to have the query prompt for the
dates.
As criteria in the [DateRenewed] field, write
Between [Enter Start] and [Enter End]

This way you'll be prompted for dates and the query can be run anytime
without need to be changed.

 

[BagelAnne]

Thank you so much, Fred.
I had done something like this begore but needed a memory
boost.

-----Original Message-----

I have a rather large membership database and I have a
report that prints labels from the membership table.
Is there an easy way for me to change the parameters of
the report on the fly to print only specific records?
I want to option to sometimes print lables of only those
members who renewed in 2004 (A field in the members

table).

Simplest way is to create query to be used as the recordsource for the
label report.

To answer your immediate question, add another column to the query
RenewedYear:Year([DateRenewed])

as criteria for the [RenewedYear] column, write:
2004

A more useful solution would be to have the query prompt for the
dates.
As criteria in the [DateRenewed] field, write
Between [Enter Start] and [Enter End]

This way you'll be prompted for dates and the query can be run anytime
without need to be changed.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.