Hi Gurus,

Can any one help me on the below requirement. I need macro which compare
rows based on unique id and give the result in the last column. But i am not
sure how to do this since i am new to Macors.
Material Concatenate Contract Pre/Post Kind post Price Date Total Message
03ZA M1L check1 1111 Pre Ball 08.01.2010 -39604950
1222 Post Product 08.01.2010 -38942981.55
New Ball 08.01.2010 -39604950 Ok

Regards,
eluru

Eluru,

I have looked as carefully as I can through your sample data, but I am
afraid I can't really understand what you aree trying to achieve. Could you
please try to explain in more detail what is supposed to happen?

--
Steve Schapel, Microsoft Access MVP


"Eluruking" <(E-Mail Removed)> wrote in message
news:2BE45177-5D1C-41AC-92D9-(E-Mail Removed)...
> Hi Gurus,
>
> Can any one help me on the below requirement. I need macro which compare
> rows based on unique id and give the result in the last column. But i am
> not
> sure how to do this since i am new to Macors.
> Material Concatenate Contract Pre/Post Kind post Price Date Total Message
> 03ZA M1L check1 1111 Pre Ball 08.01.2010 -39604950
> 1222 Post Product 08.01.2010 -38942981.55
> New Ball 08.01.2010 -39604950 Ok
>
> Regards,
> eluru