I have Access 2007 on Windows, Let my query has fields: Surname,FirstNa me,Telnumber and Phyaddress. I set Surname as parameter to create dynamic query and let user set a parameter(write down SURNAME) to display the resulted query pending on the parameter entered and then transpose the resulted query(Columns to rows);but it gives error when TRANPOSED,"Run Time error 3061,Too few parameters. Expected 1" If the parameter is removed and then TRANSPOSE it works perfectly. What should I do to use this parameter as well as to transpose my query?