Automatic Access Report - Monitor Changes in Table 1

[LevelThought]

Currently, have a Access table, that is updated daily, with fields such as:

Contract---AccountNo----OriginalValue----TodaysValue
X22--------ABC4---------$1000.00---------$2000.00
X22--------ABC5---------$2500.00---------$2600.00
X22--------ABC6---------$1500.00---------$1600.00
X23--------ABC8---------$5000.00---------$7000.00


I am interested in having a report automatically generated and e-mailed to the Manager every evening that highlights all accounts in the main Access table that have a difference greater than $900.00 between the amount in the column titled "TodaysValue" relative to the amount in the column titled "OriginalValue."

Is this possible? If so, how would I go about this?

 

[CautionMP]

Yes.[ol][li]Create a database that creates the report you want.[/li][li]Setup an AutoExec macro in this database that emails the Report then closes the database.[/li][li]Setup a Scheduled Task (assumes Windows) on the machine the new database resides on that opens the database at a specific time.[/li][/ol]

Keep in mind that you may have to jump through some hoops to get the Email function to work depending on your office environment. Depending on your setup you may get logon boxes, virus warnings...
Since the process will be fired when no one is logged into the machine you may come in the next morning and find the machine hung up somewhere in the process.

Hope this helps,
CMP

Funny thing about being unemployed, weekends don't mean quite so much, just means you get to hang out with your working friends. Primus