Avatar billede dogge Nybegynder
20. december 2000 - 23:52 Der er 4 kommentarer

SELECT statement, plz help!

Need help with a MS Access SELECT statement!
What Im trying to do is:
(Know its not working)

SELECT HEADLINE, ID, Count(ID) As Tot, Max(DATE) AS Last FROM BOOK1 GROUP BY ID ORDER by Last DESC

to get:

HEADLINE        ID    Tot  Last
--------------- ----- ----- ----------
Text 1 here    3    4    2000-12-09
Text 2 here    2    23    2000-10-01
Text 3 here    15    1    1999-10-20

Can anyone help me to get the statement right?
Regards
/Dogge
Avatar billede ikuyucu Nybegynder
21. december 2000 - 08:31 #1
OK let\'s C, It\'s look like you have a table with Headline, id and date right? Then try this:
SELECT BOOK1.headline, BOOK1.id, Count(BOOK1.id) AS Total, Max(BOOK1.date) AS Last
FROM BOOK1
GROUP BY BOOK1.id, BOOK1.headline;
Avatar billede dogge Nybegynder
22. december 2000 - 19:26 #2
Hi again and thx for the answer!

Well u got it right!
But...
My problem is that i want the result to be \"ORDER BY Last DESC\"
And by using \"group by\" \"id\" AND \"headline\" the result is wrong. It must only be \"GROUP BY headline\"

Is it possible ???

Regards
Dogge
Avatar billede dogge Nybegynder
22. december 2000 - 19:28 #3
SORRY!!!
IT MUST ONLY BE \"GROUP BY ID\"!!!
SORRY!!!
/Dogge
Avatar billede terry Ekspert
23. april 2001 - 12:34 #4
Hi Dogge

I have just started using eksperten and found your un-ansewered question. If you still need help then get in touch.

Terry
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Dyk ned i databasernes verden på et af vores praksisnære Access-kurser

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester