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

Add an extra column to your query

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

then in the condition row

Not In("Sat","Sun")


David

A crosstab query should do what you want. Use the wizard to build it. The wizard only allows three row fields but after the query is built, you can open it in design view and add more fields if necessary. You can also join the crosstab query to other tables or queries to get additional data and sometimes you need to join two crosstabs since you can only pivot a single value at a time. For example, if you wanted a sum of both hours and dollars, you would need a crosstab for each which you would then join. Base your report on the final query.