update query,question

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.
 
M

Michel Walsh

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query the same table three times 0
help! update query 7
how to do a conditional update 3
Sum values in a "chronlogical date list" from "transactions table" 5
Query Question 2
Extract user input from query into report 7
Make table query: [Enter 1] AS Test 1
Page numbering with Merged Document and IF statements 1

Top