Reply to thread

Message: [QUOTE="Bob Barrows [MVP], post: 4367172"] If I understand you correctly, the key to determining the parameter order is to test the query in Access. You should supply the parameter values in the same order that Access prompts you for them when you test the saved query. It has nothing to do with how you name your parameters (p1, p2, etc.) It's all about the order in which they appear in your sql statement. The best way to determine the proper order is to test the query in Access and keep track of the order in which you are prompted for the values. HTH, Bob Barrows [/QUOTE]