calculate based on a weekend

[icemonster]

hi.

is there a term or function within access that identifies if the given day is a weekend? cause i want to do something like:

HourseWorked*Date(If weekend, 1.5) something like this.

 

[pbaldy]

You can use the Weekday() function to test the day of the week. That and an IIf() should get you what you want.

 

[icemonster]

can you give me a sample?

 

[pbaldy]

?weekday(date())
6

 

[gemma-the-husky]

if weekday(date)<>vbsaturday and weekday(date)<>vbsunday then
etc