I removed the brackets and used
=dateserial:[year]&[month]&[day]
but is still doesn't work so any other suggestions.
The three fields I am combining are general number and I am combining into a
date/time field so could this cause the problem. Also not all the records
have data in year, month, day.
Any help is appreciated. I made the mistake of creating the table this way
and would have been so much better off with a date/time field in order to
manipulate the dates in the database. I want to update about 1000 records so
it would be so much easier to do so by an update.
"Anne" <am******@ns.sympatico.ca> wrote in message
news:Qz*********************@ursa-nb00s0.nbnet.nb.ca...
My competitors table has Memberid, lastname, first name, and I have three
other fields (all number) year month and another for day. I decided to
combine the year, month and day into one date field.
so I created a new field with a date/time format
then I created an update query and put date as my field name
and then I tried in the update section
=dateserial:([year]&{month}&[day})
and I could not get my date field to update.
I am new at this and wondered what syntax should I have used.
or is this the right way to do this.I did an internet search but couldn't
find anything useful
thanks