Unanswered: How seperate months from dates and show in query
Dear Access guys;
Just a question. Maybe it is not very professional but i need to apply it in my access project.
I have a list of hospitals that is stored in table and the shows the start and end date of hospital activity. I need to make a query to seperate the months and list the months that the hospital was active.
i have attached the file. please look at the file and you may understand will.
Use a crosstab query. Have Hospital and year as your rows and set these to group by then have the month as your column. Use the query wizard to create the query. There is one thing that could be annoying in that the months will be alphabetical order not calendar order.