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

Top