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

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

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

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

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

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