MS Access table/form into a GRID weekly meetings

P

PS

Is it possible to put a Mon-Fri time data from a table
into a grid, showing appointments for every half hour,
including free times (when no appointments are listed)?
Example is below. I truly appreciate any help available.
Mon Tues Wed Thurs Fri
8:00 Y Y Y
8:30 Y Y Y
9:00
9:30
10:00
10:30
11:00 Y Y
etc, etc.
 
M

Mike Labosh

Is it possible to put a Mon-Fri time data from a table
into a grid, showing appointments for every half hour,
including free times (when no appointments are listed)?
Example is below. I truly appreciate any help available.
Mon Tues Wed Thurs Fri
8:00 Y Y Y
8:30 Y Y Y
9:00
9:30
10:00
10:30
11:00 Y Y
Click to expand...

Off the top of my head, it sounds like you could use the crosstab query
wizard.

--
Peace & happy computing,

Mike Labosh, MCSD

"It's 4:30 am. Do you know where your stack pointer is?"
 
Top