I have an access data base that I use successfully used pass through queries to get data from AS400 database. I want to know if there is a way to create a stored procedure on AS400 and call it from Access. Basically what I am trying to do is this. I have a carrier data base. the carriers are in the AS400 database and I view them in my Access database, allot more flexible and easier to find. Each carrier has a city. I want to run a query in Access that would find the carriers in so many mile radius of a search city. On the AS400 there is a PC miler version for AS400. I want to be able to pass the city and radius to that and get the results. Is this even possible? I would think I need to create a stored procedure and somehow pass the parameters to this from Access. Am I even close?