Agenda aplication???

[bdubuc]

I am looking for tips or a template that acts like the Outlook agenda. I have to display all hours of the day on a form and the meeting description if there's one at this time. I cannot use Outlook as this would be a standalone application.

I have tried the following: a table for the hours and a table for the meetings. I can acheive what I want by using a left join on the hours table, but as soon as I apply a filter (to only get the meetingd for M. Doe), I loose my hours; only the ones that actually have a meeting scheduled appears. I need to show them all.

Any help is greatly appreciated.

Ben

 

[Rich]

Try using a crosstab query to produce the records. I do something similar.
HTH

 

[bdubuc]

I tried that, but it didn't show all time slots. Can you please detail your table structure or if you can, send it to me?

Thanks

 

[Rich]

Use the column headings property to enter all your time slots.
HTH

 

[bdubuc]

I still can't get all the time slots to show. I only time slots where there is a meeting. I am missing all the free time slots.

What I have is a table with all time slots between 9:00AM and 5:00PM (every 30 minutes) in a table and a meetings table where I have the date, time and people you have the meeting with.

I created a query with a left join to have all records from the "time" table and those corresponding in the meetings table. That works OK, but it doesn't quite have the look I need as it shoes 2 entries for the same time slot if 2 meetings are scheduled for 2 different people. It's hard to see who's available or not. I really need the look and feel of a paper agenda, where you see all the time slots for a day and you fill in the blanks. The crosstab query would be great if it were possible to have it display something like this:

Jon Doe Mary Jane Peter Parker
09:00 Sally
09:30 Dr Octopus
10:00 Goblin
10:30
11:00 M. Jamison
...

Thanks again for all the help

 

[Rich]

The crosstab itself will produce the time slots as the headers which at first glance doesn't look the way you want it, but you can change the layout on a form/report to display the way you want.
I'm home on holiday this week so I can take a look if your still stuck. It needs to be in A97 and zipped, remember to compact it first.
richiet@lineone.net