Query Parameters error of the Upsized database

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 Adp query does
not work as Accdb query after upsized the database due to parameters have
been changed. Therefore, please help me to solve the problem.

Accdb Query
SELECT *
FROM DONATIONS
WHERE (((DONATIONS.PAY_DATE)>=[forms]![report].[STR_DATE] And
(DONATIONS.PAY_DATE)<=[forms]![report].[END_DATE]));

Adp Query(After upsized)
SELECT dbo.DONATIONS.*
FROM dbo.DONATIONS
WHERE (PAY_DATE >= @forms___report___STR_DATE1) AND (PAY_DATE <=
@forms___report___END_DATE2)
 

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