Upsizing Issue with SQL Server

[whill1]

Hi All,
I have a problem with this code now. it has been working fine for over a year in Access but when I Upsized, SQL Server gives me problems:
this is code from Access:
Code1:'Expr2[ApptDetails]![ApptDate] + [ApptDetails]![ApptTime])-Eval([ApptDetails]![RemindTime])

This is how it was modified in the Upsizing process:
Code1: 'Expr2[ApptDetails]![ApptDate]' + '[ApptDetails]![ApptTime])-Eval([ApptDetails]![RemindTime])'

Error:[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting from character string.

Is there a SQl equivalent for Eval?
Is there a different approach?
Thanks to All,
W.

 

[whill1]

Hey,
I found the answer to this, the code that works is this:
'[ApptDetails]![ApptDate] + [ApptDetails]![ApptTime])-Eval([ApptDetails]![RemindTime]'
Notice the single quotes ' ' locations.
Man this gets really annoying when the wizards can't get it right.
Hope this helps somebody down the road.
W.