Hi,
Here is a very challenging problem in ms access 2007 (at least for me
)
There is a 2 column table as:
Month| Title
-------------
JAN | A
JAN | B
JAN | C
FEB | D
FEB | E
MAR | F
APR | G
APR | H
MAY | I
MAY | J
MAY | K
Problem:
This table needs to be displayed as following "in an Access table or
an Access query":
JAN| FEB| MAR| APR| MAY
-----------------------------------
A | D | F | G | I
B | E | - | H | J
C | - | - | - | K
I'm able to write this output to an Excel spreadsheet, but i've tried
n number of ways to get the exact same output as above in Access, but
I've not got any success yet.
I really need help on this - not only because I'm struggling with
this problme but also because now I am more curious in knowing how
this can be done in Access.
If you have a solution that you can provide I will highly appreciate
your help!
Thanks in advance!