I want to know how to use cross tab query
I wnat pepare monthly statement of slary for employees..for that i want to join employee table and allowance table
in employee table
in allowance table
i want report in format
empID Employeename BP HRA DA ..
How to do it using cross tab query...
Thanks In Advance