DBGrid Question: How can I implement this?- i think it´s noob question

[joelsilva]

Hi folks,

I have one table (table_1) which contains 4 fieds:
1) ID;
3) Product_Name;
2) Date;
4) Price.

I set a DBGrid to shows all my RECORDS related to some month (for example, August), ordering by date. So, it seems like:

==============================
ID Product_Name Date Price
01 Product1 01/08/2004 20.00
02 Product2 01/08/2004 10.00
03 Product3 01/08/2004 50.00
04 Product4 02/08/2004 30.00
05 Product5 02/08/2004 10.00
06 Product6 05/08/2004 20.00
07 Product7 07/08/2004 15.00
(...)
==============================

I need to put in another table(table_2 - 2 fields: Date and Amount)the amount of product´s price for DATE and shows it in another DBGrid. So, this second DBGrid will be something like:

==============================
Date Amount
01/08/2004 80.00
02/08/2004 40.00
05/08/2004 20.00
07/08/2004 15.00
(...)
==============================


How can i implement this? I am using ADO components to connect into my MS Access database.

Best regards.