Append Query Won't Post Text Box?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an append query that posts a form field (text box called "amount") to
a table. I am updating the "Amount" field automatically (=field "Qty" *
Field "Price"). The "Amount" field is appearing correctly on the form, but
when I try to append the "Amount" field into a table, only a zero appears.

I have other fields on the form that are appending correctly, but this field
will not.

I tried to requery the field after totaling it, but that doesn't work. Any
suggestions?

Thanks in advance for your help.

G
 
Why not use the expression [Qty]*[Price] in the append query, rather than a
reference to a control that has that expression?

Not sure why you're not seeing the result that you expect otherwise...
Perhaps you could post the SQL statement of the query?
 
Back
Top