hi there, the problem I'm having seems to be a common one amoung newbies to the javaJDBC world but here it goes again. I'm getting the error that I have to few parameters and I'm aware that it means there's something wrong with my code. I have checked the SQL in Access and it world perfectly. I don't know if I'm doing something worng in the implementation of the database. Please could someone take a look and point me in the right direction. Thanks
The error it kicks out is : [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. I've taken the SQL into Microsoft and it workd there so I'm not sure if there is something that I'm missing in terms of java code. I'm pretty new to this stuff so I really am not sure if I've left something out. The initial connection works when the class is initialized but once I press the command button to generate the result it bombs out.