Pass Thru query

G

Guest

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

Pass thru query question 2
Execution speed 4
Follow up to prior posting (execution speed) 1
Crystal Reports/Access Parameter Pass-Thru 2
Incorrect date in pass-thru query 1
Query Wizard help... 4
Pass-Through Query Help 12
Pass Through Make Table 7

Top