It's Working But...

D

DS

In an SQL statement can you do this?
"UPDATE tblGiftCard SET (tblGiftCard.GiftAmount +
Forms!FrmCheckPaymnt!TxtAmount) " & _
"WHERE tblGiftCardID = Forms!frmCheckPaymnt!ID;"

Basically I want to know if I can add a table amount and an amount on a
form.

Thanks
DS
 
D

Dirk Goldgar

DS said:
In an SQL statement can you do this?
"UPDATE tblGiftCard SET (tblGiftCard.GiftAmount +
Forms!FrmCheckPaymnt!TxtAmount) " & _
"WHERE tblGiftCardID = Forms!frmCheckPaymnt!ID;"

Basically I want to know if I can add a table amount and an amount on
a form.
Click to expand...

Your syntax isn't quite right, but if your purpose is to add the amount
from the form to the current amount in the GiftAmount field in the
specified record, you should be able to do it with an update query like
this:

UPDATE tblGiftCard
SET GiftAmount =
Nz(GiftAmount, 0) + [Forms]![FrmCheckPaymnt]![TxtAmount]
WHERE tblGiftCardID = [Forms]![frmCheckPaymnt]![ID]
 
D

DS

Most Perfect!
Thank you, Dirk
DS
Dirk Goldgar said:
DS said:
In an SQL statement can you do this?
"UPDATE tblGiftCard SET (tblGiftCard.GiftAmount +
Forms!FrmCheckPaymnt!TxtAmount) " & _
"WHERE tblGiftCardID = Forms!frmCheckPaymnt!ID;"

Basically I want to know if I can add a table amount and an amount on
a form.
Click to expand...

Your syntax isn't quite right, but if your purpose is to add the amount
from the form to the current amount in the GiftAmount field in the
specified record, you should be able to do it with an update query like
this:

UPDATE tblGiftCard
SET GiftAmount =
Nz(GiftAmount, 0) + [Forms]![FrmCheckPaymnt]![TxtAmount]
WHERE tblGiftCardID = [Forms]![frmCheckPaymnt]![ID]

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Click to expand...
 
Top