i have a table

name, desc, podate

with name/desc character and podate a date field


it is a table of vender names line descriptions and purchase order dates

i need to find the last time a order was placed

this is my query

select name,desc from mytable group by name,desc where (select
max(podate) from mystuff)

i keep getting syntax errors

can you help
tia
peter

Try this:

SELECT [name], [desc], (SELECT Max(mystuff.podate)
FROM mystuff WHERE mystuff.[name] =
mytable.[name]) FROM mytable
GROUP BY [name], [desc];


--

Ken Snell
<MS ACCESS MVP>


"ilaboo" <plener (AT) earthlink (DOT) net> wrote

Ken Snell wrote:

i am dealing with only i table called mystuff

tia
peter

podate is in table mystuff? Then it's easy:


SELECT [name], [desc], Max(podate)
FROM mystuff
GROUP BY [name], [desc];
--

Ken Snell
<MS ACCESS MVP>

"ilaboo" <plener (AT) earthlink (DOT) net> wrote

Ken Snell wrote:
thank
you
i think i was leaving the ; out

thanks
peter