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!
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?
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.
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...
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.
Is facebook not loading right for anyone else?
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.
Yesterday on a helpdesk call, the IT guy said "Oh. That's interesting..."
I knew it was going to be a loooooooooooooooong call.
Any iPhone users familiar with ReQall?
[link]
It looks sort of similar to Tasker, which I know Android users in here rave about.
I used Reqall before I had an iPhone. I don't use it at all now.