unable to run the query

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]));

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

--
Lynn Trapp
Trainer/Application Developer


"Niroshana" wrote in message
...
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]));

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.

--
Daryl S


"Niroshana" wrote:

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]));