Recent content by desertbird

That is good to know, Thank you! I did see some suggestion on using debug.print early on trying to figure out my Dmax issue, but am lost on what and where. Would you happen to have a good URL that explains it for dummies like me?

That works!!!!!!! WOOOOOOO HOOOOOOOOO!!!!! I owe you a case of beer, a bottle of wine or what ever your favorite drink is. I have been trying to get this figured out for a week! THANK YOU SO MUCH!!!!!!

I tried that route in the beginning, but it doesn't work too well. I then found out how to use DMax, but get lost on the additional criteria for more then one user and job. Manly around where the double quotes and single quotes go and when to [ ] a field etc.

Thank you so Much Plog!!!! Yes, sorry about the Date, it's actually named CI_Date. I tried your expresssion as: DMax("[CI_Date]","Data","[CI_Date]<#" & [CI_Date] & "# AND UserID='" & [UserID] & "' AND Job='" & [Job] & ''") but I get and don't know what to change:

Hello, thanks for the insight, yes there is DateDiff. That is what I use to calculate "Elps Days" in my example and don't need help with. I need help with figuring out the "PrevDate" Field....

Hello All, I am having trouble with a query where I want to calculate the number of days between dates where I have a UserID, JOB, and Date. To do that all I need is the previous Date "PrevDate" each UserID was in a JOB. I do not have any issues writing a DMax to do this when I only have one...