Hi!
I'm trying to solve a wish from our users. Our database contains two fields - "price of spare part from manufacturer" and "price of spare part from others". The goal is to be able to see where you can get spare parts at the best price and how much you save. Our users now want a list of e.g. the 5 records with the biggest difference between price from manufacturer and others.
So I need a routine to check each record, compare these two fields, and then list the 5 records with the biggest difference between these two fields.
I've searched through this forum and Karen's site at hypermart, but I didn't find anything similar to this wish.
I appreciate all the time you spend helping others and I hope someone can help me out here.
Thank you.
Regards
Batdilla
http://baatplassen.no
I'm trying to solve a wish from our users. Our database contains two fields - "price of spare part from manufacturer" and "price of spare part from others". The goal is to be able to see where you can get spare parts at the best price and how much you save. Our users now want a list of e.g. the 5 records with the biggest difference between price from manufacturer and others.
So I need a routine to check each record, compare these two fields, and then list the 5 records with the biggest difference between these two fields.
I've searched through this forum and Karen's site at hypermart, but I didn't find anything similar to this wish.
I appreciate all the time you spend helping others and I hope someone can help me out here.
Thank you.
Regards
Batdilla
http://baatplassen.no