Pull a report automatically between two days

[Ruenells]

I am looking to have a report that was working in Crystal Reporting and I am now trying to get to work in MS Access.

I currently have to manually enter the date and time range I want the report to be.

I want to be able to hit the button on the switchboard and have it lauch and pull the correct information.

I need it to pull from Tuesday at 11:00 am of the current week to Thursday to 3:00 pm of the current week and also from the current Tuesday 11:00 am to the following Tuesday (one Week out until 3:00 pm.

This did work in Crystal, the problem is I can no longer access the code.

I am desparate for any help!!

 

[jbenson001]

forum701

 

[SQLBill]

Microsoft SQL Server (this forum) and Access use two different versions of SQL. That's why there is a forum for MS Access and why JBenson001 suggested you try there.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875