halo everyone,
im trying to create calculated field in a query (or a table) that sum the records in other field, if those records have the same ID (field) and has early or the same date/time (field).
i made an exmple in excel, the blue column is the calculated field.
as you can see, every row with "123" as ID sum the earlier "amount" field.
thx.