Parameter Query - Weekending date

MsLady

Traumatized by Access
Local time
Today, 10:29
Joined
Jun 14, 2004
Messages
438
I am trying to tell this query to get the wkending of the date (timeInDate). My query run but returns no data. Can anyone be kind enough to look at the red part?

SELECT tblOvertime.overtimeId, tblOvertime.peopleId, tblOvertime.timeIn, tblOvertime.timeInDate, tblOvertime.timeOut, tblOvertime.timeOutDate, tblOvertime.authorizedBy, tblOvertime.clientmatter, tblOvertime.dinnerMoneyTaken, tblOvertime.loggedBy, tblOvertime.comments, tblOvertime.lastUpdatedBy, [FirstName] & ", " & [Lastname] AS FullName
FROM tblOvertime INNER JOIN tblPeople ON tblOvertime.peopleId=tblPeople.PeopleId
WHERE ((((tblOvertime.peopleId)=Forms!frmOvertime!PeopleId Or (tblOvertime.peopleId)=Forms!frmOvertime!PeopleId Is Null)=True) And format((DateAdd("d",7-Weekday(timeInDate),timeInDate)),"mm/dd/yy")=Forms!frmOvertime!txtWkEnding Or format((DateAdd("d",7-Weekday(timeInDate),timeInDate)),"mm/dd/yy")=Forms!frmOvertime!txtWkEnding Is Null)=True
ORDER BY tblOvertime.timeIn, tblOvertime.timeInDate DESC;
 
anybody? Please help
eusa_pray.gif
 
Thanks all, you've all been very helpful :rolleyes: I fixed the issue anyways :D
 

Users who are viewing this thread

Back
Top Bottom