By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,524 Members | 1,253 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,524 IT Pros & Developers. It's quick & easy.

The Year() Function and Update Queries

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.