Strong like an Amazon.

Tara ,'Storyteller'


Buffistechnology 3: "Press Some Buttons, See What Happens."

Got a question about technology? Ask it here. Discussion of hardware, software, TiVos, multi-region DVDs, Windows, Macs, LINUX, hand-helds, iPods, anything tech related. Better than any helpdesk!


tommyrot - May 10, 2012 6:58:56 am PDT #20036 of 25501
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.

OK, I think this is what you need:

Say you have a table called tbltest, with a unique ID of ID, a field 'stuff' and a dateadded field. You could try this:

SELECT tbltest.ID, tbltest.stuff, tbltest.dateadded
FROM tbltest

where tbltest.dateadded = (select max(dateadded) from tbltest)

However, if you have more than one record with the same maximum date, it will return all the records with that maximum date.

Is this what you need?


Sophia Brooks - May 10, 2012 7:13:50 am PDT #20037 of 25501
Cats to become a rabbit should gather immediately now here

I think so! Someday I will learn this stuff. We have a database designer, but I have been asking for this modification for over 3 years, and we are a really low priority.


EpicTangent - May 10, 2012 2:41:36 pm PDT #20038 of 25501
Why isn't everyone pelting me with JOY, dammit? - Zenkitty

Heh - I am Zen. I saw the start of a post and went, "Hey, I know Access!" but inside of two lines...blah blah Ginger...


Sophia Brooks - May 10, 2012 2:46:25 pm PDT #20039 of 25501
Cats to become a rabbit should gather immediately now here

The blah blah Ginger is sort of why I asked the question!

I do love that the "blah blah Ginger" is such a useful quote.


sarameg - May 10, 2012 3:34:39 pm PDT #20040 of 25501

Is facebook not loading right for anyone else?


tommyrot - May 10, 2012 3:39:11 pm PDT #20041 of 25501
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.

Seems fine for me.


Toddson - May 11, 2012 6:01:35 am PDT #20042 of 25501
Friends don't let friends read "Atlas Shrugged"

Thouht for the day: if you're having a problem with anything - a program, application, etc. - and the person who knows about it says "oh, you just ..." you're in trouble.


Jessica - May 11, 2012 6:06:03 am PDT #20043 of 25501
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset

Yesterday on a helpdesk call, the IT guy said "Oh. That's interesting..."

I knew it was going to be a loooooooooooooooong call.


Jessica - May 11, 2012 6:38:49 am PDT #20044 of 25501
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset

Any iPhone users familiar with ReQall?

[link]

It looks sort of similar to Tasker, which I know Android users in here rave about.


le nubian - May 11, 2012 8:16:09 am PDT #20045 of 25501
"And to be clear, I am the hell. And the high water."

I used Reqall before I had an iPhone. I don't use it at all now.