Hi,
I have a table with each day & totals related to that day. Dates will vary and number, perhaps 20 or more but I think will restrict to 30 although data may ask otherwise but will have to worry about that on the screen space.
I know not really how access is meant to process, display data but I have a situation that would be so much better if I could have the dates across the top.
I would really like to view it like this on a form.
Would be OK to have two separate subforms but DateX & DSpaces on one & DateX (again) & BSpaces if a limitation of the crosstab (which I read)
I messed around with the crosstab & ended up with lots of data & rows I could not quite work out.
Toying with the ideal of making a table with x (dates) number of AutoColumns using VBA but think messy.
Any ideas,
thanks I/A
I have a table with each day & totals related to that day. Dates will vary and number, perhaps 20 or more but I think will restrict to 30 although data may ask otherwise but will have to worry about that on the screen space.
I know not really how access is meant to process, display data but I have a situation that would be so much better if I could have the dates across the top.
Datex | DSpaces | DSpacesO |
18-Aug-23 | 3 | 0 |
19-Aug-23 | 2 | -3 |
20-Aug-23 | 1 | -4 |
21-Aug-23 | 8 | -1 |
22-Aug-23 | 8 | 6 |
I would really like to view it like this on a form.
18-Aug-23 | 19-Aug-23 | 20-Aug-23 | 21-Aug-23 | 22-Aug-23 |
3 | 2 | 1 | 8 | 8 |
0 | -3 | -4 | -1 | 6 |
Would be OK to have two separate subforms but DateX & DSpaces on one & DateX (again) & BSpaces if a limitation of the crosstab (which I read)
I messed around with the crosstab & ended up with lots of data & rows I could not quite work out.
Toying with the ideal of making a table with x (dates) number of AutoColumns using VBA but think messy.
Any ideas,
thanks I/A