Report with parameter and reset feature

  • Thread starter Thread starter Tracy
  • Start date Start date
T

Tracy

I have created a report that serves as an update as it
lists only records that have been changed and/or added
since the previous report.

The table contains a check box field to indicate whether
or not the record has been changed and a date/time field
that is automatically populated when the record is
created.

The report is based on a query in which the criteria
for "Change to Record" is listed as "Yes" and to
generate the report, I change the criteria in the date
field of the query. This works fine.

I would like to make two changes to the report:

1. I want to change the format of the report so that the
user would be prompted to enter a date and;

2. I would like the change to record field to "clear"
each time the report has been printed so the record won't
automatically be included in the next report.

Is this doable?

I would appreciate any ideas anyone would have.
 
First: as far as the date is concerned. You can add a
[Enter Date] to the criteria field in the underlying
query, you can add operators like > or < etc as needed.
Second: You can create a macro that would run an update
query settin to null all the "changed" checkboxes in the
table. You can call that macro in the on close for the
report.
Hope this helps.
Fons
 
Thanks, I'll try it.
-----Original Message-----
First: as far as the date is concerned. You can add a
[Enter Date] to the criteria field in the underlying
query, you can add operators like > or < etc as needed.
Second: You can create a macro that would run an update
query settin to null all the "changed" checkboxes in the
table. You can call that macro in the on close for the
report.
Hope this helps.
Fons
-----Original Message-----
I have created a report that serves as an update as it
lists only records that have been changed and/or added
since the previous report.

The table contains a check box field to indicate whether
or not the record has been changed and a date/time field
that is automatically populated when the record is
created.

The report is based on a query in which the criteria
for "Change to Record" is listed as "Yes" and to
generate the report, I change the criteria in the date
field of the query. This works fine.

I would like to make two changes to the report:

1. I want to change the format of the report so that the
user would be prompted to enter a date and;

2. I would like the change to record field to "clear"
each time the report has been printed so the record won't
automatically be included in the next report.

Is this doable?

I would appreciate any ideas anyone would have.

.
Click to expand...
.
Click to expand...
 
Back
Top