Hi,



It ages since I did anything with Paradox and I have what I think is silly
problem that I just can't get my head around.



I have a 60k record table with two fields, ProductCode and DateSold; there
are many entries for each ProductCode with the corresponding date of sale.
I want to query the table to produce a results table giving the ProductCode
and the most recent DateSold for each product.



I'm sure this should be easy but I'm damned if I can see how to do it, can
any help?



Regards,

Trevor

In article <fYKho.114916$ki7.92091 (AT) newsfe24 (DOT) ams2>,
Trevor Guy <trevor (AT) ewh (DOT) co.uk> wrote:
Ditto, but I can help you (hopefully) based on my SQL...

In SQL terms, what you want is max(DateSold), but I have no clue how to
execute this with Paradox.
--
Aahz (aahz (AT) pythoncraft (DOT) com) <*> http://www.pythoncraft.com/

[on old computer technologies and programmers] "Fancy tail fins on a
brand new '59 Cadillac didn't mean throwing out a whole generation of
mechanics who started with model As." --Andrew Dalke

On 8 Sep 2010 12:52:54 -0700, Aahz wrote:

I just tried "Calc Max" in a QBE and it worked.

Bill