Update year field query

[Steve Muir]

I need to update a field "year" which is a combo box using data from table
"tblyear" which is basically 1,2,3,4 or 5.
"year" field is to be updated to "1" if record falls between 01/01/01 and
31/12/01 etc.
When I run the query it is returning the correct number of records but it is
not updating the "year" field. Instead it is blanking the "date" field which
it should just be checking to determine which year number to update to "year"
field.

Any help greatly appreciated

 

[Beth Melton]

Is the Year field a number or a DateTime data type?

What field are you trying to update? A DateTime field? If so what
calculation are you using to update the field? The DateAdd function?
Another function??

Also note you may want to post this question along with the additional
information I've requested to one of the Access newsgroups in order to
obtain a faster response.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/