Pass Thru query

S

Shell

I'm using Access 2000, trying to write a pass-thru query to a SQL SVR table.
I can get to the table, but when I insert criteria, the query dies.

I need to capture data for a date range from today(which changes every day)
thru 35 days ago.

Can anyone help?

Thanks
 
D

Douglas J. Steele

Pass-through queries know nothing about Access parameters.

You'll have to go into the SQL of the query and hard-code the date range.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Execution speed 4
Pass thru query question 2
Follow up to prior posting (execution speed) 2
Incorrect date in pass-thru query 1
Space at end of multi page list to accommodate new entries 1
Crystal Reports/Access Parameter Pass-Thru 2
Pass Through Make Table 7
sqlite-odbc write conflict 2

Top