Search results

yes, of course. Actually the serial and the product name are from other parties, I have no right to define them. That's why cause troubles.

Exactly what I need! Thank you so much!

it doesn't work, the file attached. it would be nice if you can take a look.

if right([serial],3) are same, and right([product],1) are same also, will be regarded as a same product.

does it means another table to keep such information? if do so, i have to creat a new table, and insert new data manually. Any method to avoid manual work?

Thanks theDBguy, it doesn't work. Because ProA and NewA have different serial and product name (but they do have some relation). they can not sum such easily.

A complicated query, anyone can help? Thanks a lot!

I just have hands on access, because excel can not work well on huge data scale. It seems quite different from what i am familiar, so I need some help in such a cyber world.