Need help with Access query following an "Upsizing"

[bkr6891]

I recently upsized my MS Access BE to an SQL server. Everything seems
to works great with the exception of a few queries (other queries are
still working great). When I try to execute the queries, I get
"expression is typed incorrectly or is too complex to be evaluated"
error message. These queries executed without a problem prior to
upsizing from Access. I will post the code from one of my problem
queries:

PARAMETERS [Forms]![frmCostPerTx]![ClinicNumber] Text ( 255 ),
[Forms]![frmCostPerTx]![BeginningDeliveries] DateTime,
[Forms]![frmCostPerTx]![EndDeliveries] DateTime;
SELECT tblProducts.ProductNumber, tblProducts.ProductName,
tblDeliveries.Quantity, tblClinics.ClinicNumber,
tblClinics.ClinicName, tblCategories.ProductCategory
FROM (tblCategories RIGHT JOIN (tblAccounts RIGHT JOIN tblProducts ON
tblAccounts.AccountID = tblProducts.AccountID) ON
tblCategories.ProductCatID = tblProducts.ProductCatID) LEFT JOIN
(tblClinics RIGHT JOIN tblDeliveries ON tblClinics.ClinicID =
tblDeliveries.ClinicID) ON tblProducts.ProductID =
tblDeliveries.ProductID
WHERE
(((tblClinics.ClinicNumber)=[Forms]![frmCostPerTx]![ClinicNumber]) AND
((tblAccounts.AccountNumber)="1540005") AND
((tblDeliveries.DeliveryDate) Between
[Forms]![frmCostPerTx]![BeginningDeliveries] And
[Forms]![frmCostPerTx]![EndDeliveries]));


Can anyone help me with this problem?

Thanks in advance for your help.
-Brian

 

[Guest]

Check all of your parameters again. Test the query only
when the forms are open, so that the parameters have true
values.

If that doesn't work, I assume that you are having some problem
with the date formatting, which you may have to do explicitly,
using a 'format' command and # delimiters.

(david)