Recordsource based on non-table data

[casey]

Recordsource based on every date

Hello all,

This may be a really dumb question and I'm no stranger to those so here goes...

I would like to create a scheduler calendar on a form from scatch perhaps using a subform(not an ActiveX control). It will be based on a table with appointments and should be displayed like a calendar showing all dates in the month. The problem is that some dates will contain no appointments at all while others will have appointments (those with appointments I can figure out how to query on). Can I create a query that would show every date in a particular month even if some dates do not have appointments? I have no idea how this would be done, but if it's possible, I could create a subform that would look exactly like a calendar.

Any ideas. Or should I be disbarred from this forum now for being stupid?

Open to any thoughts on this. Thanks.

 

[Travis]

1. Create a temporary table and add all of the dates to it. Use a "Union All Query" to merge the query and the Temp Table.

2. Open the Appointment query as a virtual recordset and append the missing dates.

 

[casey]

Thanks Travis.

O.K. that's going to make things so easy. I've never used make-table queries, but there's a lot of time to figure it out. Now that I know that it can be done, I can envision how it's going to work.

Thanks for giving me the means to get started.