Hello Naomi,

As with Borislav's SQL statement as well, :

I ran the SQL statement and it gives me many BASEPRICE per CUSTCODE AND ITEMNUMBER.

I don't know why it is returning multiple records for the same custcode and itemnumber.

I want 1 record with the current base price only.

If there something I am missing?

John