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

  • Thread starter Thread starter Fred's
  • Start date Start date
F

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

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




Hi John,

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

Thanks, 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]
Click to expand...




Hi John,

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

Thanks, 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]
Click to expand...




Hi John,

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

Thanks, Fred's
 
Hi John,

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

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]
 
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
 
Aaron Kem.pf is posting under a new alias.

Tom Wimpernark said:
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
Click to expand...
 
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]
Click to expand...



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

- Show quoted text -
Click to expand...

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
 
OpenReport, oddly enough.

John W. Vinson [MVP]
Click to expand...

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

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]
 
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.
 
Back
Top