Convert Vertical-Style Date Subform to Horizontal

  • Thread starter Thread starter Larry R Harrison Jr
  • Start date Start date
L

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
 
I would consider an unbound form with code that fills the text boxes. Use a
command button to update values back into the table.
 
Back
Top