Entrepreneur

Dustin Stanley

<div>
Thank you Gustav. I will try this in the morning. Have a great night!
</div>


Thank you Gustav. I will try this in the morning. Have a great night!

<div>
THANK YOU! This worked perfectly. I did have a small issue with the dates so I used in my query:<br />
<br />
Between DateAdd(&quot;d&quot;,-7,DatePreviou<wbr />sWeekday(D<wbr />ate(),4)) And DatePreviousWeekday(Date()<wbr />,4)
</div>


THANK YOU! This worked perfectly. I did have a small issue with the dates so I used in my query:

Between DateAdd("d",-7,DatePreviousWeekday(Date(),4)) And DatePreviousWeekday(Date(),4)

<div>
Yes, the constants are not known in SQL.
</div>


<div>
<div class="content wysiwyg-content">
I am needing some help with the Weekday function in a query criteria. I have never used it so I don't have much experience. I am working on a payroll system currently. <br />
<br />
The idea here is to pay the employees on Fridays. &nbsp;The paycheck will consist of the days Wednesday until Tuesday. Then the employee receives the check on that following Friday.<br />
<br />
I am having trouble understanding how to put this together. I thank you for help.
</div>
</div>


I am needing some help with the Weekday function in a query criteria. I have never used it so I don't have much experience. I am working on a payroll system currently. 

The idea here is to pay the employees on Fridays.  The paycheck will consist of the days Wednesday until Tuesday. Then the employee receives the check on that following Friday.

I am having trouble understanding how to put this together. I thank you for help.

MS Access Need Help With Query Criteria and Weekday Function Showing Last Wednesday To This Last Tuesday

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.