Month table of work days????

[paulmcdonnell]

Hi Guys, and happy christmas...

I need to create a table (or query) for a month (say jan) which shows all the work days within it.

I then need to drag info from my other query chowing how many appointments are booked in for that day. This part I'm ok with but its creating a table or query for any particular month and displaying all the work days Mon - Fri whether thay have apps or not that I'm strugglig with.

Had a good few attempts but It's taking ages... any ideas?

thanks in advance..

Paul

 

[DCrake]

Add an extra column to your query

DOW:Format([YourDateField],"ddd")

then in the condition row

Not In("Sat","Sun")


David