Most updated record to excel spreadsheet

[jaminewok]

Does anyone know how to transfer only the most recently updated record from access to excel? i can only get the whole recordsheet to transfer over.

 

[SiJP]

Have you got something that identifies it as the most recent record (e.g. a date/time field)?

------------------------
Hit any User to continue

 

[jaminewok]

sorry for the lack of clarification. i have a justified form, and i need to transfer only the most recent entry in the form from access to the first line of an excel sheet.

 

[SiJP]

So, like when you'r user clicks on 'next' you want the entry he's just done to be thrown into excel yeah?

Have you got a primary key for your recordset?

Is it a blank spreadsheet or a new spreadsheet you need the line transfered over to?

------------------------
Hit any User to continue

 

[jaminewok]

I do not have a primary key, but I can add one if necessary. I hope to transfer to a blank spreadsheet that already exists.

"So, like when you'r user clicks on 'next' you want the entry he's just done to be thrown into excel yeah?"

That is exactly what I want to do.

Thanks