Append Query ?

[dede]

Sorry again me but I still have quite some problem with access !! Sorry for it

table1 ] table2
Autonum. field2 Status ] field1 field2
001 2020 testing ] 2020 free
002 2020 rest ] 2021 rest
003 2020 free ] 2022 testing
004 2021 testing ]
005 2021 rest ]
006 2022 testing ]


How could I create the table2, mean field2 with the latest satus

 

[Allen Browne]

See:
Getting a related field from a GroupBy (total) query
at:
http://www.mvps.org/access/queries/qry0020.htm

 

[dede]

Many Thank's Allen, It's a great help
have a nice day... and never the less as well a nice new year !!

See:
Getting a related field from a GroupBy (total) query
at:
http://www.mvps.org/access/queries/qry0020.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Sorry again me but I still have quite some problem with access !! Sorry
for it

table1 ] table2
Autonum. field2 Status ] field1 field2
001 2020 testing ] 2020 free
002 2020 rest ] 2021 rest
003 2020 free ] 2022 testing
004 2021 testing ]
005 2021 rest ]
006 2022 testing ]


How could I create the table2, mean field2 with the latest satus