I seeeeeeeee.

You really have to spell it out to the system dontcha

I'm starting to get really peed off now. In the original statement how do I change it so the it asks:-

if [H4CURR]= 'CHF', then (H3PRBL-H3POD+H3POD+H3IOD+H3AIBL+H3FOD)/1.5476,else(H3PRBL-H3POD+H3POD+H3IOD+H3AIBL+H3FOD)

AS LNRTotalClaimEUR

Thank you once again. My sanity is preserved

Thats fixed it thanks

I copy and pasted from MS Access (too much to ask that products from the same family use the same sql I s'pose)

What does it mean then...