Hi,
I have data in my access table in the below format -
Month Employee Name Salary
Jan-06 Alan $25000
Feb-06 Susan $50000
Can anyone help me to provide me SQL code, which is compatible with
access, to swap the month into column, i.e. in the below format -
Employee Name Salary Jan-06 feb-06 March-06
I tried it by making cross tab, but cross tab only shows the result
of
select query and it does not make the table.
Also cross tab allows only three field in the rows, please also help
how to make more fields in the rows in the cross tab query.
I would really appreciate the kind support.
Regards
Chandervesh Arora
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
