Import most recent records from access db to word

[hometech]

Hello Guys, I want to import contents from an access database into a word table.

the main issue is this, in my access database i have a table that looks just like this




S/N
DATE
NAME
ITEM
INITIAL
ADDITION
TOTAL


1
31/09/13
James
Computers
500
100
600


2
31/09/13
Peter
Machinery
1000
50
1050


3
31/09/13
Stone
Transport
700
-
700


4
1/10/13
James
Computers
500
200
700


5
1/10/13
Stone
Transport
700
200
900


6
4/10/10
Sarah
Telephones
1500
-
1500



Okay now i want to be able to import the most recent record for each sales person from my access database into my word table in order to have something like this




S/N
DATE
NAME
ITEM
INITIAL
ADDITION
TOTAL


4
1/10/13
James
Computers
500
200
700


2
31/09/13
Peter
Machinery
1000
50
1050


5
1/10/13
Stone
Transport
700
200
900


6
4/10/10
Sarah
Telephones
1500
-
1500




Although i have been able to import records from my access database into word based on the date

I just want to select the most recent records for each sales person. Thanks

[mrojas]

In access, create a query to pull the most recent records from the table, then import results of query.

[hometech]

In access, create a query to pull the most recent records from the table, then import results of query.

Thanks mrojas, but the access query just pulls out the single most recent record