Form/Subform creation

[Blondie96]

I have a form which shows information about a request for scheduling a room type. The user can schedule multiple days @ differing times with the same request. That part is done in a different form & process.These are tied to a tracking #

I want a summary form which shows all the info in the request table (Tracking #, office, username....

Then in a subform(or multiples I want to show something that looks like:

Room Name: 1
Start Day StartTime End Day EndTime
3/1/2005 0900 03/01/2005 1200
3/10/2005 1800 03/15/2005 0500
...

Room Name: 2
03/22/2005 1000 03/23/2005 0100


Tracking # is stored in schedule file along w/room Name. & dates & times.


Can someone tell me how I could create this layout.

Thanks,

Tamra

 

[PHV]

This is a Report layout with grouping on room name.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Blondie96]

I wanted this in a form, not a report. Does the same function exist there?

Thanks,

Tamra