Snapshot Viewer Reports - Variable Data Missing from emailed file.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jim - 10 Mar 2008 23:55 GMT

Periodically we email an Access 2000 report using snapshot viewer. The
report is based upon user input varible date data which control the
underlying query and two text boxes that display the "from" and "to" period.
When the report is previewed or printed, at the sending location, the dates
are displayed on the report however, when the report is emailed, the dates
are missing from the recipient's file? Any suggestions would be greatly
appreciated.

Signature

J. Monroe
SofTrain

Reply to this Message

DialAround - 13 Mar 2008 16:19 GMT

It sounds as through the text boxes are on a form or something other than the
query. You could try omiting the text boxes and editing the query. In the
query, type the following criteria under the date field:
between [Enter beginning date] and [Enter ending date]

Then include the date field in your report.

> Periodically we email an Access 2000 report using snapshot viewer. The
> report is based upon user input varible date data which control the
[quoted text clipped - 3 lines]
> are missing from the recipient's file? Any suggestions would be greatly
> appreciated.

Reply to this Message