help! update query

  • 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 Date1 field and the date
2/2/2005, I want to place the value in the Number2 field.
Can someone tell me how to do this?

Thank You.
 
-----Original Message-----
I am creating an update query, which returns the number of
days between the values in Date1 field and the date
2/2/2005, I want to place the value in the Number2 field.
Can someone tell me how to do this?

Thank You.
.
repost can someone help me with this
Click to expand...
 
-----Original Message-----
repost can someone help me with this
Click to expand...

Be a little more patient...

UPDATE MyTable SET MyTable.Number2Field = #2/2/2005#- [Date1];

--
Joan Wild
Microsoft Access MVP

Thank you Joan, I do appreciate your help. I am new at
Click to expand...
this, I had a hard time getting posted, I will be patient.

I tried this, I am getting a message when I run it, that
says there must be a destination field. What can I do?
 
Margaret said:
UPDATE MyTable SET MyTable.Number2Field = #2/2/2005#- [Date1];
--
Joan Wild
Microsoft Access MVP

Thank you Joan, I do appreciate your help. I am new at
Click to expand...
this, I had a hard time getting posted, I will be patient.

I tried this, I am getting a message when I run it, that
says there must be a destination field. What can I do?
Click to expand...

You need to modify it to reflect the names of your table and field(s)
i.e.
MyTable - change to the name of your's
Number2Field - change to the field that will be updated
Date1 - change to the field that has the date
 
Back
Top