[AccessD] Copy a record in a table

On 14 Nov 2006 at 17:11, Beach Access Software wrote:

> 
> Dear List:
> 
>  
> 
> Is there a quick or slick or elegant way to copy a record in a table to a
> new record in the same table - just duplicating a record  

INSERT INTO tblTable
SELECT tblTable.*
FROM tblTable
WHERE  fldID = IDofRecordToCopy