unable to run the query

  • Thread starter Thread starter Niroshana
  • Start date Start date
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]));
 
What do you mean by "does not run"? Are you getting an error message? If so,
what is it?
 
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.
 
Back
Top