Hello,
I have a table "myTable", with the folowwing data :
i want a query that returns only those records that have a unique set of field values . in this case i would like to return:
is this done with a query or dao.recordset ?
I have a table "myTable", with the folowwing data :
dataM | aValue | bValue | cValue |
31-dez-23 | 19,73 | 15,86 | 52,56 |
31-dez-23 | 19,73 | 52,56 | 15,86 |
31-dez-23 | 52,56 | 15,86 | 19,73 |
31-dez-23 | 52,56 | 19,73 | 15,86 |
31-dez-23 | 26 | 31,71 | 80 |
31-dez-23 | 26 | 80 | 31,71 |
31-dez-23 | 31,71 | 26 | 80 |
31-dez-23 | 31,71 | 32 | 74 |
31-dez-23 | 31,71 | 50 | 56 |
31-dez-23 | 31,71 | 56 | 50 |
31-dez-23 | 31,71 | 74 | 32 |
31-dez-23 | 31,71 | 80 | 26 |
31-dez-23 | 32 | 31,71 | 74 |
31-dez-23 | 32 | 74 | 31,71 |
31-dez-23 | 50 | 31,71 | 56 |
31-dez-23 | 50 | 56 | 31,71 |
31-dez-23 | 56 | 31,71 | 50 |
31-dez-23 | 56 | 50 | 31,71 |
31-dez-23 | 74 | 31,71 | 32 |
31-dez-23 | 74 | 32 | 31,71 |
31-dez-23 | 80 | 26 | 31,71 |
31-dez-23 | 80 | 31,71 | 26 |
i want a query that returns only those records that have a unique set of field values . in this case i would like to return:
dataM | aValue | bValue | cValue |
31-dez-23 | 19,73 | 15,86 | 52,56 |
01-jan-24 | 26 | 31,71 | 80 |
02-jan-24 | 31,71 | 32 | 74 |
03-jan-24 | 31,71 | 50 | 56 |
is this done with a query or dao.recordset ?