Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Query to pull all Records in the Past 48 hours from today
I have tried to use the =Date()-2 and it does not return any records. I have also tried DateAdd("d",=2,Date()) and not getting any results either. I am sure it is something simple I am missing Am I doing something wrong. I am trying to create 2 separate reports 1. 48 Hours in the Past 2...- Ruenells
- Thread
- Replies: 9
- Forum: Microsoft: Access Queries and JET SQL
-
Pulling a Report Automatically between two days
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...- Ruenells
- Thread
- Replies: 11
- Forum: Microsoft: Access Queries and JET SQL
-
Pull a report automatically between two days
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...- Ruenells
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
