Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

calendar in a subform

Status
Not open for further replies.

ruyeno22

Programmer
Aug 14, 2001
19
PA
hello:

i want to know if its possible to create a subform with the following layout:

january 2001

monday tuesday ....
1 2

shift 1 e1 e2

shift 2 e2 e1

all the information is stored in a table: the day of the month, the month, the weekday of THAT day of the month, and e1, e2 (are employees).

i need to put info horizontally (days of week and days of moth) and vertically (employees)

as you can see, its like a crosstab query, but i dont know how to do it.

 
When creating the subform, change the default view property from "single form" to "datasheet". That will put your fields vertically, instead of horizontally.

Let me know if you need further assistance!

--Angela O.
 
Hi!

Well, basically if you select datasheet view the information will be shown horizontally, and the column headers will be the name of the columns.

all the rows are shown horizontally, with each record occupying a row.

what i want is to show records vertically. the information of a record must be shown one field below the other.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top