changing labels criteria

  • Thread starter Thread starter BagelAnne
  • Start date Start date
B

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).
 
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).
Click to expand...

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.
 
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
Click to expand...
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.
.
Click to expand...
 
Back
Top