The Year() Function and Update Queries

[Gobi]

Hello everyone,
I have a database of clients that has a Date_Closed Field and a
Table_Name field along w/other various client infor. At the end of the
year, files get moved into a "History" table that is used for old
Client searches. I need to write a update query that places
"CLOSECurrentYEAR" ie CLOSE2002 CLOSE2003 into the Table_Name Field
I Have tried to concatinate "CLOSE & Year()& " in the expression
builder but It did not work

In the Criteria Box I have "IS Null" because when the records are
placed in the History Table the Table_Name field is always null....I
ran It with the Update To: as "CLOSEYear()" and ended up in the
Table_Name field for the right records but it needs to say CLOSE2004
not CLOSEYear()

How do I Place the current Year after the text "CLOSE" in an update
query

Thanks Much
Any Help Will be much appreciated

[fredg]

On 13 Jul 2004 09:23:17 -0700, Gobi wrote:

Hello everyone,
I have a database of clients that has a Date_Closed Field and a
Table_Name field along w/other various client infor. At the end of the
year, files get moved into a "History" table that is used for old
Client searches. I need to write a update query that places
"CLOSECurrentYEAR" ie CLOSE2002 CLOSE2003 into the Table_Name Field
I Have tried to concatinate "CLOSE & Year()& " in the expression
builder but It did not work

In the Criteria Box I have "IS Null" because when the records are
placed in the History Table the Table_Name field is always null....I
ran It with the Update To: as "CLOSEYear()" and ended up in the
Table_Name field for the right records but it needs to say CLOSE2004
not CLOSEYear()

How do I Place the current Year after the text "CLOSE" in an update
query

Thanks Much
Any Help Will be much appreciated

"CLOSE & Year()& "
should be:
"CLOSE" & Year([Date_Closed])
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.