unable to run the query

N

Niroshana

I have upsized my Access 2007 database to SQL server 2005 database (Front end
Access Database and Back end SQL server Database). Following MS Access query
does not run after upsized the database. Therefore, please help me to solve
the problem.
SELECT *
FROM DONATIONS
WHERE (((DONATIONS.PAY_DATE)>=[forms]![report].[STR_DATE] And
(DONATIONS.PAY_DATE)<=[forms]![report].[END_DATE]));
 
L

Lynn Trapp

What do you mean by "does not run"? Are you getting an error message? If so,
what is it?
 
D

Daryl S

Niroshana -

You didn't say what is not working, but one thing to check is the format of
the date fields. You may need to format the STR_DATE and END_DATE to match
what SQL Server is expecting.
 

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

MS Access Query criteria Problem 2
Access-SQL query error 4
Question on Pass-through Query 4
Operation must use an updateable query 13
Application.HyperLink vs controlname.HyperlinkAddress 4
Using of sql server for back end database 3
Pass Through Query - not returning rows 1
Action Query (Append) didn't add records due to key violations. 5

Top