Create a New Table with values other than a column in another table and relate it

[Syndicate_Admin]

Good morning

I wish you could help me with the next consultation.

I have a table 1 where I manage a record of unit entry dates. If in a day 5 units enter I have 5 records.

I would like to create a new table with a "date" column that has the unique values of the column of table 1 and also create a new column "quantity" where the sum of total income of units according to that date is.

Of this....

TABLE 1

New table...

Tuesday 7 ----3

Wednesday 8 ----5

and so on.

Thank you

[Ahmedx]

Is this what you are looking for?

[Syndicate_Admin]

That's right.

Thanks a lot.