table creation run time

i have a table which has fields code,month,year,expenses.
when i finished input for years.i want that tables should be
created for unique code,year.i.e. records for perticular year and perticular code in one table and another in other it should create nos of table as many unique codes in table for perticular year.
i will give user selection for year and code if required in frontend.
i never done it before so some body please guide me how to do it.i am using adodb or adodc and access as backend.
help required usrgently .please help
Ganesh :)


  • use the CREATE TABLE statement in SQL. If you do it in VB or VBA, you can modify the sql string you send to include the specific year etc. Look up CREATE TABLE in the msJetSQL reference under "Data manipulation language".


Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


In this Discussion