Query/ report- print report each wednesday with the data entered from the previously week

[Fred's]

Hello all,

My boss asked me to print a report each wednesday, my next print will
be the 16 of May with data that I previously entered between 7 to 11
of May.

If there a way to create a query and then create a report which I can
print each wednesday with the data entered from the previously week?

Your help will be much appreciated!!

Thanking you all in advance,
Fred's

 

[John W. Vinson]

Hello all,

My boss asked me to print a report each wednesday, my next print will
be the 16 of May with data that I previously entered between 7 to 11
of May.

If there a way to create a query and then create a report which I can
print each wednesday with the data entered from the previously week?

Your help will be much appreciated!!

Base the Report on a query with a criterion on the date field in your table of

BETWEEN DateAdd("d", -7, Date()) AND Date()

If you want Access to be automatically opened and print the report, create a
Macro to run the report, and use Windows Scheduler to open the database. The
command line should contain a parameter to execute the macro, e.g.

"C:\Program Files\Microsoft Office\Office12\msaccess.exe"
"E:\somepath\yourdatabase.mdb" /x RunReport

John W. Vinson [MVP]

 

[Fred's]

Base the Report on a query with a criterion on the date field in your table of

BETWEEN DateAdd("d", -7, Date()) AND Date()

If you want Access to be automatically opened and print the report, create a
Macro to run the report, and use Windows Scheduler to open the database. The
command line should contain a parameter to execute the macro, e.g.

"C:\Program Files\Microsoft Office\Office12\msaccess.exe"
"E:\somepath\yourdatabase.mdb" /x RunReport

John W. Vinson [MVP]

Hi John,

How access can guess which date to which date the report need to be
printed?

Thanks, Fred's

 

[Fred's]

Base the Report on a query with a criterion on the date field in your table of

BETWEEN DateAdd("d", -7, Date()) AND Date()

If you want Access to be automatically opened and print the report, create a
Macro to run the report, and use Windows Scheduler to open the database. The
command line should contain a parameter to execute the macro, e.g.

"C:\Program Files\Microsoft Office\Office12\msaccess.exe"
"E:\somepath\yourdatabase.mdb" /x RunReport

John W. Vinson [MVP]

Hi John,

How access can guess which date to which date the report need to be
printed?

Thanks, Fred's

 

[Fred's]

Base the Report on a query with a criterion on the date field in your table of

BETWEEN DateAdd("d", -7, Date()) AND Date()

If you want Access to be automatically opened and print the report, create a
Macro to run the report, and use Windows Scheduler to open the database. The
command line should contain a parameter to execute the macro, e.g.

"C:\Program Files\Microsoft Office\Office12\msaccess.exe"
"E:\somepath\yourdatabase.mdb" /x RunReport

John W. Vinson [MVP]

Hi John,

How access can guess which date to which date the report need to be
printed?

Thanks, Fred's

 

[John W. Vinson]

Hi John,

How access can guess which date to which date the report need to be
printed?

Windows Scheduler is just that - a schedular. It lets you specify the exact
date and time that the command will be launched, and the repeat interval
(annually, daily, every ten seconds if you wish).

John W. Vinson [MVP]

 

[Tom Wimpernark]

SQL Server and Access Data Projects includes this thing called SQL Agent;
this is 100 times more powerful.

Do you want to send an email if a procedure fails?
it doesn't take any code with Sql Agent!

MDB is ridiculolus, move to a database with a future!

-aaron

 

[George Hepworth]

Aaron Kem.pf is posting under a new alias.

SQL Server and Access Data Projects includes this thing called SQL Agent;
this is 100 times more powerful.

Do you want to send an email if a procedure fails?
it doesn't take any code with Sql Agent!

MDB is ridiculolus, move to a database with a future!

-aaron

 

[Fred's]

Base the Report on a query with a criterion on the date field in your table of

BETWEEN DateAdd("d", -7, Date()) AND Date()

If you want Access to be automatically opened and print the report, create a
Macro to run the report, and use Windows Scheduler to open the database. The
command line should contain a parameter to execute the macro, e.g.

"C:\Program Files\Microsoft Office\Office12\msaccess.exe"
"E:\somepath\yourdatabase.mdb" /x RunReport

John W. Vinson [MVP]

Hi John, where can I found Windows Scheduler on windows 2000?

 

[Fred's]

Hi John, where can I found Windows Scheduler on windows 2000?- Hide quoted text -

- Show quoted text -

Hi John, How can I create a Macro to run the report? Which macro
action do I used?

By the way, I 've found the Windows Scheduler

Thank you,
Fred's

 

[John W. Vinson]

Hi John, How can I create a Macro to run the report? Which macro
action do I used?

OpenReport, oddly enough.

John W. Vinson [MVP]

 

[Fred's]

OpenReport, oddly enough.

John W. Vinson [MVP]

Hi John,

what do you mean by "The command line should contain a parameter to
execute the macro ?
"C:\Program Files\Microsoft Office\Office12\msaccess.exe"
"E:\somepath\yourdatabase.mdb" /x RunReport

And where do I put these path?

Thank you,
Fred's

 

[John W. Vinson]

what do you mean by "The command line should contain a parameter to
execute the macro ?
"C:\Program Files\Microsoft Office\Office12\msaccess.exe"
"E:\somepath\yourdatabase.mdb" /x RunReport

And where do I put these path?

These two lines should be combined into one (messages word wrap so I can't
show it as one line), edited to have the actual drive, path name, and database
name, and put into the command line window on Windows Scheduler.

John W. Vinson [MVP]

 

[Long Live Aaron Kempf]

Warning!

John Vinson is a known troll; he does nothing but run around promoting MDB

I would reccomend finding a credible SQL Server developer / dba in order to
suit your needs.