I have a query in Access that get's it's info from linked DB2 tables. I'm trying make it a parameter query (different date needed everytime it's run). The problem is that it won't run....I get ODBC-call failed error message every time. Query works fine when I specify a date in the criteria row in access, just not when i set a parameter for same date field. The data type in the Query parameter window in access is set to Date/Time. I've tried same query with different parameters set on different fields w/ different datatypes and it works just fine....What am I doing wrong?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Parameter query
- Thread starter Andande
- Start date
Similar threads
- Locked
- Question