SQL statement about going to

I need to write a SQL statement in MS Access Query to select last record only from a table. I tried several time and could not find the solution. I hope some expert can give me a hand. Thank you!

所有跟帖: 

回复:SQL statement about going t -lidongmei- 给 lidongmei 发送悄悄话 (91 bytes) () 06/30/2004 postreply 18:46:10

回复:回复:SQL statement about going t -tryyyyyy- 给 tryyyyyy 发送悄悄话 (48 bytes) () 06/30/2004 postreply 18:52:09

there is no "last record" -f64- 给 f64 发送悄悄话 (382 bytes) () 06/30/2004 postreply 19:07:30

Solutions for future ... -DBDB- 给 DBDB 发送悄悄话 (361 bytes) () 06/30/2004 postreply 20:20:58

回复:there is no "last record" -tryyyyyy- 给 tryyyyyy 发送悄悄话 (47 bytes) () 06/30/2004 postreply 20:45:40

回复:there is no "last record" -tryyyyyy- 给 tryyyyyy 发送悄悄话 (82 bytes) () 06/30/2004 postreply 21:55:46

This is for SQL Server, not -smartll- 给 smartll 发送悄悄话 (60 bytes) () 07/01/2004 postreply 01:02:23

It work in Access -tryyyyyy- 给 tryyyyyy 发送悄悄话 (0 bytes) () 07/01/2004 postreply 07:01:29

回复:回复:there is no "last record" -MD/PHD/IT- 给 MD/PHD/IT 发送悄悄话 (213 bytes) () 07/01/2004 postreply 13:35:43

请您先登陆,再发跟帖!