Recent content by ruenells

umm ok...lost what does that mean and how do i do it? Sorry don't understand. Rue

I have not resolved this, in fact it has gotten worse. I am basically trying to pull any information that would be for the past 2 days...so it doesnt matter if i have to put it in in hours or days just the last 2 days 00:00 to 11:59 pm Here is the SQL SELECT [48_Hour_Pull].Expr1...

I am looking for the second 00:00:00 to 23:59 and i am only pulling from the Planned Start field

nope it is very clean. It just is not pulling it so that is why I am asking if there is a way to pull it based on the time since the other criteria is not working I think it should work as well but I am stuck!

Planned-Start Planned-Finish 1/24/2008 9:00:00 AM 1/24/2008 1:00:00 PM 1/24/2008 9:00:00 AM 1/25/2008 10:00:00 AM 1/24/2008 8:30:00 PM 1/24/2008 11:00:00 PM

Ok I tried what you suggested and it pulled 2 records leaving off the third that was done at 8:30pm last night. That is why I am wondering how to get all the records?

So how do I do that then?

Sorry I guess I was not clear I am looking for all records for the last 24 hours. or the last day from midnight to midnight

Well I switched it around still didnt pull anything past the time on my pc?

Between (DateAdd("d",0,Date())) And (DateAdd("d",-2,Date()))

Here is my issue I am having, With the records we are pulling it is not pulling everything from the previous 24 hours. It is using the "D" to pull the information, however it is also using the default system time, so if i have a record that occured last night at 8:30 pm it is not showing up...

Well I am happy to report IT WORKS!! That being said, this is the next part I forgot. Go figure right! Currently it is pulling for the past 2 days. Here is my problem. Tues, Wed, Thurs, Fri, Need to be prior 2 days standard report Mon needs to be for the prior 3 days covering Friday...

Thanks I will try it out and let you know!! Really appreicate all your efforts towards resolving this!! Get some rest!! Rue

Brian, I am not sure exactly what you did but it looks good. Now comes the big question what do I do with it LOL. I will wait for your reply before I miss something up lol

in the table it is actually EXPR1, sorry I have renamed it in the original database