D
Dan
I have a linked database that i am pulling data from but when I try to add a
parameter in one of the feilds I get the ODBC error, when I try to run the
query. If I take this Parameter value out and just input the data directly
into the criteria feild it runs fine. Is there a way to run the ODBC with a
parameter value? If so could someone help me. I have attached my SQL view
below.
SELECT [MA#FILECEN_MAPILOC].ILITEM, [MA#FILECEN_MAPITCO].ICDESC,
[MA#FILECEN_MAPILOC].ILBIN1, [MA#FILECEN_MAPILOC].ILDUNT,
[MA#FILECEN_MAPILOC].ILONHD, [MA#FILECEN_MAPITCO].[ICMAN#],
[MA#FILECEN_MAPITCO].ICKWD1
FROM [MA#FILECEN_MAPILOC] INNER JOIN [MA#FILECEN_MAPITCO] ON
[MA#FILECEN_MAPILOC].ILITEM = [MA#FILECEN_MAPITCO].ICITEM
WHERE ((([MA#FILECEN_MAPILOC].ILITEM)=[Enter Item Number:]) AND
(([MA#FILECEN_MAPILOC].ILHOSP)=132) AND (([MA#FILECEN_MAPILOC].ILLOCN)="ST"));
parameter in one of the feilds I get the ODBC error, when I try to run the
query. If I take this Parameter value out and just input the data directly
into the criteria feild it runs fine. Is there a way to run the ODBC with a
parameter value? If so could someone help me. I have attached my SQL view
below.
SELECT [MA#FILECEN_MAPILOC].ILITEM, [MA#FILECEN_MAPITCO].ICDESC,
[MA#FILECEN_MAPILOC].ILBIN1, [MA#FILECEN_MAPILOC].ILDUNT,
[MA#FILECEN_MAPILOC].ILONHD, [MA#FILECEN_MAPITCO].[ICMAN#],
[MA#FILECEN_MAPITCO].ICKWD1
FROM [MA#FILECEN_MAPILOC] INNER JOIN [MA#FILECEN_MAPITCO] ON
[MA#FILECEN_MAPILOC].ILITEM = [MA#FILECEN_MAPITCO].ICITEM
WHERE ((([MA#FILECEN_MAPILOC].ILITEM)=[Enter Item Number:]) AND
(([MA#FILECEN_MAPILOC].ILHOSP)=132) AND (([MA#FILECEN_MAPILOC].ILLOCN)="ST"));