update query,question

  • Thread starter Thread starter Margaret
  • Start date Start date
M

Margaret

I am creating an update query which returns the number of
days between the values in the Date1 Field and the date
2/2/2005, I placed the value in the Number2 Field. This is
the value I entered into Number2. =#2/2/2005# - [Date1],
however I am receiving an error message, saying Must have
at least on destination Field, when I try to run the
update query, can someone tell me what I am doing wrong.

Thank You.
 
Hi,


In the designer? You probably have uncheck the box to "show" the field. You
must at least have one shown (selected) field... to have something to
return, as data...



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top