Access Queries - Microsoft Community

in query below wish sum values in 'sumofqtys' & sumofexpr columns/fields relating duplicated fields in 'item' column  , remove duplicates thecolumn 'item'. e.g. 'balsamic vinegar' duplicated  follows;

dish       pob item                         grp          meas sumofqty price sumofexpr
ztest1 15 balsamic vinegar p & j's 250mls 0.2               £2.50           £37.50
ztest3 10 balsamic vinegar p & j's 250mls 0.6               £2.50           £25.00

i know how create code associated query above , similar fields read thus;

item                         grp          meas sumofqty      price      sumofexpr
balsamic vinegar      p & j's 250mls      0.8               £2.50           £62.50

ciao,

delete duplicate records query:

https://support.office.com/en-us/article/delete...

counting data using query:

https://support.office.com/en-us/article/count-...

please let know if work you.


ugo

Office / Access / Microsoft Office Programming / Office 2016