Passthru Query 1

[Xzibit7]

I have a table in access that I want to inner join with data that I am getting through a passthru query. However I keep getting an error message table not found. Here is my code, any help would be appreciated


SELECT National_Stock_Number, Acquisition_Method_Code, Acquisition_Method_Suffix_Code, Annual_Demand_Value, Total_On_Hand_Qty, Acquisition_Cost, Total_Quantity_On_Backorder, critical_item_code
FROM DSS_USER.C_FILE INNER JOIN Table1 ON National_stock_Number =Table1.NSN

 

[PHV]

you have to create a query that join your saved passthru query with your table.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Xzibit7]

Thanks,thats what I was afraid of...I already have that implemented and was just hoping to speed up the process there are hundreds of thousands of entries in the pass thru query and it takes a fairly long time to sort the data