V
vman92
I am not having any troubles appending data to a table using the
following SQL in Access 2003. However, when I try to run it in Access
2000 I get the 'Run time error 5": Invalid procedure call or argument'
I don't understand what is going on.
1st query
INSERT INTO TempHoldforEOM ( Field8, Field11, Field4, Field5, Field6,
Vendor )
SELECT [StringExtract-Concatenation].Field8,
[StringExtract-Concatenation].Field11,
[StringExtract-Concatenation].Field4,
[StringExtract-Concatenation].Field5,
[StringExtract-Concatenation].Field6,
[StringExtract-Concatenation].Vendor
FROM [StringExtract-Concatenation], [StringExtract-ConcatenationB]
WHERE ((([StringExtract-Concatenation].Expr2)=[Expr4]));
Concatenation Query
SELECT Left([CleanInterim]![Field11],InStr(1,[CleanInterim]![Field11],"
")-1) AS Expr1, CleanInterim.Field6, [Expr1] & [CleanInterim]![Field6]
AS Expr2, CleanInterim.Field8, CleanInterim.Field4,
CleanInterim.Field5, CleanInterim.Vendor, CleanInterim.Field11
FROM CleanInterim;
Concatenation Query B
SELECT Left(CleanedHistory!Field11,InStr(1,CleanedHistory!Field11,"
")-1) AS Expr3, CleanedHistory.Field6, [Expr3] & CleanedHistory!Field6
AS Expr4
FROM CleanedHistory;
Any help would be greatly appreciated.
P.S. I already moved DAO 3.6 up underneath the Acces 9.0 library & ran
a Compact/Restore.
following SQL in Access 2003. However, when I try to run it in Access
2000 I get the 'Run time error 5": Invalid procedure call or argument'
I don't understand what is going on.
1st query
INSERT INTO TempHoldforEOM ( Field8, Field11, Field4, Field5, Field6,
Vendor )
SELECT [StringExtract-Concatenation].Field8,
[StringExtract-Concatenation].Field11,
[StringExtract-Concatenation].Field4,
[StringExtract-Concatenation].Field5,
[StringExtract-Concatenation].Field6,
[StringExtract-Concatenation].Vendor
FROM [StringExtract-Concatenation], [StringExtract-ConcatenationB]
WHERE ((([StringExtract-Concatenation].Expr2)=[Expr4]));
Concatenation Query
SELECT Left([CleanInterim]![Field11],InStr(1,[CleanInterim]![Field11],"
")-1) AS Expr1, CleanInterim.Field6, [Expr1] & [CleanInterim]![Field6]
AS Expr2, CleanInterim.Field8, CleanInterim.Field4,
CleanInterim.Field5, CleanInterim.Vendor, CleanInterim.Field11
FROM CleanInterim;
Concatenation Query B
SELECT Left(CleanedHistory!Field11,InStr(1,CleanedHistory!Field11,"
")-1) AS Expr3, CleanedHistory.Field6, [Expr3] & CleanedHistory!Field6
AS Expr4
FROM CleanedHistory;
Any help would be greatly appreciated.
P.S. I already moved DAO 3.6 up underneath the Acces 9.0 library & ran
a Compact/Restore.