I'm working on a MS Access database, there's one table linked from a ODBC database.
In the ACESS table, I defined 2 fields,A and B, each of them maps the field in the ODBC table. A field C in the ODBC database can return a unique value with both the info. A and B.
We want the C value can be...
Tried the cross-tab, it seems like it didn't work.
The actual data format we want to creat is like the followings.
Jan Feb March April,,,
Comany1 Projection 000 000 000 000
Sales 000 000 000 000
Ordered 000 000 000 000
Company2 Projection...
The normay table we can easily creat is like below. All the groups are vertically created.
Group1
Group10 Data100 D101 D102
Group11 D110 D111 D112
Group12 D120 D121 D122
Group2
Group10 D200 D201 D202
...
We want to create a report, one of the groups is created horizontal. like...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.