Hoow to Obtain Last Date Worded Proceeding Current Date

[djclntn]

I have a Form & a Sub Form within.
Main Form flds: “EmplyDate’, ‘EmloyeeID’, ‘Emplhrs’
Sub Form: ‘EmplloyeeID’, ‘Co’ (County), ‘City’, ‘LastDateWorked”

The ‘LastDateWorked' in the query is Min



The 2-Forms are linked by, EmployeeID. What I want is, on any particular day say 1/22/2014 if Employees, Joe, Frank, & Donna are working then in a Sub Form I want to see what Co & City the reside. But I also want to see the last previous date they worked from the current date. I don’t know what (if any) I can write to have these results? Allow me to provide some examples of what I’m shooting for:

Main Form:

• EmplDate: 1/22/1014
• EmployeeID: JoePMrphy
• EmplHrs: 4.5

Sub Form

• EmployeeID
• Co
• City
• LastDateWorked *How can I populate the last previous date they worked from the current date?

Any suggestions would be greatly appreciated!

[ItsMe]

Maybe have add a subform to your main form and flatten it out with its control's Locked. This could provide you with the ability to view the summary you need. Use "SELECT TOP 2" in your subform's recordsource. So, in the subform's SELECT query add "TOP 2" directly after SELECT.