View Single Post
  #1  
Old December 8th, 2009, 02:42 PM posted to microsoft.public.access.queries
Niroshana
external usenet poster
 
Posts: 3
Default Query Parameters error of the Upsized database

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)