Looking for value

[syedadnan]

Regards,

I have a query where i want something like this;

Field name as Unit_A consume unit 100
Field name as Unit_B consume unit 103

Rate Consumed are in two different numeric field named Rate_A & Rate_b

What i want is,

like Unit_A consumed less unit then B so the less rate from Rate_A & Rate_B to be come with Unit_A and same as for other like Unit_B

:banghead:

 

[vbaInet]

Unfortunately it doesn't make much sense to me. Can you show us some data in a spreadsheet, and also include how you would like it to look.