Ok then I would like a table in the form that has values
along the top and down the left hand side..
OK... as I suspected, it was clashing jargon.
A Table, in Access, is the basic storage medium for data; if you open
the database the first tab on the database window is the list of
Tables. I was assuming that's what you meant.
You're talking about "a table" in common English, not the technical
term!
Does this help any?
Yes.
I have some fields above and below my table so it will be
inserted as a sub form.
Is this possible?
It's difficult to have it updateable. You can do it with a Crosstab
query but only for data display.
If your table is normalized properly, and you want this appearance,
you will need to either use an unbound Form and write VBA code to poll
through all the checkboxes, writing the data out to the tall-thin
table; or use a denormalized wide-flat table bound to the subform, and
write the data out to the normalized table using an Append query.
