Convert Vertical-Style Date Subform to Horizontal

[Larry R Harrison Jr]

I have Access 97 and a subform which shows scheduling. It shows the current
week. There are 3 shifts per day, thus there are 21 entries per week in the
table linked to this subform. This table is the "child" in a "parent-child"
type of relationship between another table (often called a "one-many"
relationship).

Its style looks like this:

Date Shift Qty Part#
11-9 1 150 999
11-9 2 150 999
11-9 3 150 999
....
....
11-15 1 150 999
11-15 2 150 999
11-15 3 150 999

...with the 1st date being the Sunday of that week, the last being the
Saturday of that week. I already have code taken care of the issue of
generating entries for the current week by sensing days of the week and
creating entries, etc. No problems there.

The thing is, I'd rather it look something more like this:

Sun Mon Tues Wed Thur Fri Sat
Shift 1 1 1 1 1 1 1
Qty 150 150 150 150 150 150 150
Shift 2 2 2 2 2 2 2
Qty 150 150 150 150 150 150 150
Shift 3 3 3 3 3 3 3
Qty 150 150 150 150 150 150 150

Ultimately, I'd even like it to only show one shift at a time; tab-controls
could be used to split up each shift that way. But for now the above layout
will suffice.

Seems as though a crosstab query would be the tool to pull this off. But I
really don't seem to have that knack to get it to shape it that way.

Tips?

LRH

 

[Duane Hookom]

Do you want to be able to enter or edit data in this format?

 

[Larry R Harrison Jr]

Do you want to be able to enter or edit data in this format?

Yes I do.

 

[Duane Hookom]

I would consider an unbound form with code that fills the text boxes. Use a
command button to update values back into the table.