eh?

[scottobear]

Comments

[rgladiator.livejournal.com]

Whats up doc?

[canyoncat.livejournal.com]

Bears have antlers down there? COOL!

Re:

[scottobear.livejournal.com]

not lots! check your mail! that SQL should be there!

SELECT timedate.Date_Field, Count(timedate.Date_Field) AS CountOfDate_Field, Last(timedate.Time_Field) AS LastOfTime_Field
FROM timedate
GROUP BY timedate.Date_Field;

[scottobear.livejournal.com]

Not as far as I know! ;P

Almost

[rgladiator.livejournal.com]

The query displays the last time in the table per date but not the latest time. I tried sorting the table by date and time(to put the latest time last in the table) but no luck. i.e. the results for 4/1 should have been 3:50 PM but came back 8:57 AM. Help meh please!

Re: Almost

[scottobear.livejournal.com]

SELECT timedate.Date_Field, Count(timedate.Date_Field) AS CountOfDate_Field, Max(timedate.Time_Field) AS MaxOfTime_Field
FROM timedate
GROUP BY timedate.Date_Field;


sorry! my booboo!

Re: Almost

[scottobear.livejournal.com]

I did last instead of "max". :) I misthought that the last entry would be the most up to date.

Re: Almost

[scottobear.livejournal.com]

Date_Field CountOfDate_Field MaxOfTime_Field
4/1/2002 15 3:50:45 PM
4/2/2002 20 5:29:37 PM
4/3/2002 25 6:29:28 PM
4/4/2002 16 5:06:23 PM
4/5/2002 21 5:46:46 PM
4/8/2002 23 5:37:31 PM
4/9/2002 23 6:02:25 PM
4/10/2002 19 5:14:04 PM
4/11/2002 19 9:35:31 PM
4/12/2002 23 6:29:08 PM
4/14/2002 4 4:23:13 PM
4/15/2002 25 6:09:01 PM
4/16/2002 32 7:00:19 PM
4/17/2002 28 5:08:49 PM
4/18/2002 23 10:48:41 PM
4/19/2002 24 6:19:29 PM
4/20/2002 1 12:13:39 PM
4/21/2002 2 1:14:34 PM
4/22/2002 19 6:04:42 PM
4/23/2002 21 7:19:38 PM
4/24/2002 22 5:38:08 PM
4/25/2002 19 5:25:09 PM
4/26/2002 26 5:37:49 PM
4/27/2002 1 8:48:16 AM
4/28/2002 2 8:35:46 PM
4/29/2002 18 5:50:32 PM
4/30/2002 19 6:10:30 PM
5/1/2002 19 4:42:26 PM
5/2/2002 23 4:10:57 PM
5/3/2002 22 5:14:27 PM
5/4/2002 1 2:14:45 PM
5/5/2002 1 12:44:28 PM
5/6/2002 18 5:43:37 PM
5/7/2002 26 8:09:13 PM
5/8/2002 16 4:14:01 PM
5/9/2002 24 4:55:28 PM
5/10/2002 12 4:50:12 PM
5/11/2002 1 5:32:07 PM
5/13/2002 21 4:51:24 PM
5/14/2002 33 6:31:12 PM
5/15/2002 24 5:24:49 PM
5/16/2002 21 5:17:03 PM
5/17/2002 16 4:48:10 PM
5/18/2002 1 11:34:53 AM
5/19/2002 1 3:11:20 PM
5/20/2002 29 8:07:17 PM
5/21/2002 20 6:25:42 PM
5/22/2002 25 7:04:56 PM
5/23/2002 20 6:57:20 PM
5/24/2002 24 4:52:23 PM
5/26/2002 1 11:23:40 AM
5/27/2002 2 12:13:40 PM
5/28/2002 32 7:37:11 PM
5/29/2002 17 9:11:22 PM
5/30/2002 22 5:22:40 PM
5/31/2002 23 4:57:50 PM

Re: Almost

[rgladiator.livejournal.com]

Woo hoo! Thanks again.

Re: Almost

[scottobear.livejournal.com]

quite welcome! :) happy to help.

Re: Almost

[rgladiator.livejournal.com]

Syntax always kills me. Thats why I don't program. I usually can work out all the logic of what I want to do but I don't know/can't remember the @#$! commands.

Re: Almost

[scottobear.livejournal.com]

http://www.albinoblacksheep.com/audio/allmms.html

Programming good! mmMm! :)