Simple referencing, I think!

[Shadez]

just an idea but you could try using

rst.Fields("[Field]").value

instead of

rst![Field]

or it could be

rst.Fields("Field").value

not cirtain if you need the [] or not.


Another idea if you want to remove "/"'s from your field names use sql like this

sql = "Select [C/F] as CF, EELoan, Profit, NetProfit, Tax from test"

now the [C/F] field is just CF.

 

[Pete64]

YOU R A LEGEND

yeah am talkin about you Shadez

just as I thought there was no hope, nice all is clear in world Access now, until the next problem

this seemed to work a treat:

Cal1 = rst.Fields("[C/F]").Value + rst!EELoan - rst!Profit

CHeers for all that help

Case CLosed

~ SOLVED ~

 

[Shadez]

No probs m8


ShadeZ