Recent content by Ruenells

Basically I need to pulls 2 days in the past and 2 days ONLY in the future. Right now what has been suggested is working for the past but for the future I am getting all future records.

SELECT [48_Hour_Pull].Expr1, [48_Hour_Pull].[2-Change-Category], [48_Hour_Pull].Status, [48_Hour_Pull].[Planned-Start], [48_Hour_Pull].[Planned-Finish], [48_Hour_Pull].[1e-Requestor], [48_Hour_Pull].[Emergency-Approver], [48_Hour_Pull].Expr2, [48_Hour_Pull].[1b-Description]...

Also I tried your suggestion and no records are being returned?

Thanks for the reply. I am looking for the last 48 hours meaning 2 days. The field the information is pulling from is a combo of date/time. I know that they share the field anyway. But I really am looking for anything that has occured in the last 2 days not specific to hours. Hope that clarifies

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...

Sorry it took me so long to reply back but THANK YOU! This worked perfect!! You rock! Rue

I pasted exactly what you gave me and this is what i got DateAdd("d",-Weekday(Date())+3,Date())+#11/24/2007# And DateAdd("d",-Weekday(Date())+5,Date())+0.625 I did not add the date when i hit enter it converted to that format

Thank you so much for responding, however perhaps I am not being clear. Tomorrow morning I will be manually entering [Start Date] and an [End Date] with the following information. 12/18/07 11:00 am and 12/20/07 3:00 pm I am looking to see if there is a way to have the times remain the same...

ok i must be stupid because when i put that in the query grid it wants to make it a date and puts the # and completes the dates for me. I am so confused now

also can you please explain the 11/24 and the .625 I am not sure what you are calling.

The times are always the same, however the day of the week will always be the same, however it will always be the current weeks tuesday.

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...

I'm sorry I am new to this forum. Did i miss something here?

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...

I am having a simular issue, what I am trying to recreate is a report that runs from Tuesday to Thursday and Tuesday to Tuesday. It was working in Crystal but I am unable to recreate it in Ms Access. I do not want to have to enter the dates at all I want to be able to run the report and have...