Access 2002 vs 2003

[Erik Vandamme]

The query below works in acess 2002 but not 2003???
In fact it is worse in the query below it is the Cstr$ that causes the
problem

INSERT INTO JapanImpByMonth ( YearMM, Country, HS, Quantity, Yen, USD,
[Month] )
SELECT [Year]*100+1 AS Expr3, qJapanImportKate.CountryName,
qJapanImportKate.HS, qJapanImportKate.[Quantity2-Jan],
qJapanImportKate.[Value-Jan], [Value-Jan]*0.5 AS Expr1,
'Jan-' & Right$(Cstr$([Year]),2) AS Expr2
FROM qJapanImportKate;

 

[Douglas J. Steele]

Did you try to repair your references, as I suggested elsewhere?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

The query below works in acess 2002 but not 2003???
In fact it is worse in the query below it is the Cstr$ that causes the
problem

INSERT INTO JapanImpByMonth ( YearMM, Country, HS, Quantity, Yen, USD,
[Month] )
SELECT [Year]*100+1 AS Expr3, qJapanImportKate.CountryName,
qJapanImportKate.HS, qJapanImportKate.[Quantity2-Jan],
qJapanImportKate.[Value-Jan], [Value-Jan]*0.5 AS Expr1,
'Jan-' & Right$(Cstr$([Year]),2) AS Expr2
FROM qJapanImportKate;

In 2003 it has: Office11.0 Object Library and DAO 3.6 that does not work
In Office 2002 same but it works, unfortunately client has 2003
Is this a matter of no newer DAO libary? (being deprecated perhaps)

 

[Erik Vandamme]

for sure

 

[Erik Vandamme]

Conclusion expression Cstr$() has been deprecated and Cstr() remain
neat that even the Converter does not notice this, so have to examine
all queries by hand...