dlast with string criteria

[mxfrail]

I am probably just missing something -

dlast(""chargeid"", ""tblcontractaddlchargeshdr"", ""UserEntered ="" & CurrentUser)"

I error unknown.

My full sql is -

DoCmd.RunSQL "Update tblContractAddlChargesHDR set expirationdate = #" & txtToDate & "#, effectivedate = #" & txtFromDate & "# where chargeid = dlast(""chargeid"", ""tblcontractaddlchargeshdr"", ""UserEntered ="" & CurrentUser)"

Can anyone help with this? Thanks.

 

[HarleyQuinn]

Maybe:

DoCmd.RunSQL "Update tblContractAddlChargesHDR set expirationdate = #" & txtToDate & "#, effectivedate = #" & txtFromDate & "# where chargeid = dlast(" & Chr(34) & "chargeid" & Chr(34) & ", " & Chr(34) & "tblcontractaddlchargeshdr" & Chr(34) & ", " & Chr(34) & "UserEntered = " & CurrentUser & Chr(34) & ")"

Hope this helps

HarleyQuinn
---------------------------------
Carter, hand me my thinking grenades!

Get the most out of Tek-Tips, read FAQ222-2244: How to get the best answers before post

http://lessthandot.com

 

[dhookom]

I would never expect DLast() to provide an accurate value against an unordered table.

Duane
Hook'D on Access
MS Access MVP