Microsoft Access question

[Whoop]

Maybe an easy one, probably not.

I have a table that contains multiple delivery dates for a product -


fish 02/06/07
fish 08/06/07
fish 14/06/07
fish 22/06/07
fish 28/06/07
frog 02/06/07
frog 08/06/07
frog 14/06/07
frog 22/06/07
frog 28/06/07


As an example. All I want is

fish 02/06/07
frog 02/06/07

How do I get Access to pick up just the first date in the table, I am trying to get a report of next delivery date for each product but I end up with all of them. anyone know?

Thanks,


Whoop

 

[Moe]

Hi,

Just create a query in Access and add the fields that you want then in SQL mode do something like:

select table.product, max(table.date) from

group by table.product;

Moe.