SQL and Access

[Matt_Hirst]

I have a table that I need to create a set number of records in depending on a user selection, i.e. user selects 4 so 4 records are created now I have tried to do this using SQL and here in lies the problem.

I am wanting the record to use the default values for the fields apart from one, this field will have the same numeric value across the set of records.

Is htere a way to do this or do I have to supoply the default value for each field in the record being created?

e.g. User selects 2

so run the following statement twice.
Insert Into table1 (field1, field 2, ..., field 23) Values ('1','2','m'...)

regards,

Matt

 

[Matt_Hirst]

Thanks for this, was bugging the hell out of me so I posted this message then got it sorted abot an hour later !

regards,

Matt

 

[Matt_Hirst]

One further question say I had a table, table1, the records are all index stamped relating to when they were input, if three of these records were related how would I write an sql statement to remove the last record enterred?


regards,

Matt