V
vmsanchez
This is a query I've used regularly in Access 2.0 and Access97 with no
problems.
Interesting enough, when I remove the "Document No" parameter, I don't get
an ODBC error. Instead, I am prompted for the "date" and after I type in
"01/31/03" the records display. Any suggestions...comments?
See SQL code below. Thanks,
Vince
SELECT DISTINCTROW ARLINH.Docno, ARLINH.Location, ARLINH.Custkey,
ARLINH.Itemkey, ARLINH.Unitprice, ARLINH.Ordqty, [Unitprice]*[Ordqty] AS
[Sale Amount], ARLINH.Docdate, ARLINH.Cost, [Sale Amount]-[Cost]*[Ordqty] AS
[Gross Profit]
FROM ARLINH
WHERE (((ARLINH.Docno)=[Document No]) AND ((ARLINH.Docdate)=[date]))
ORDER BY ARLINH.Docno;
problems.
Interesting enough, when I remove the "Document No" parameter, I don't get
an ODBC error. Instead, I am prompted for the "date" and after I type in
"01/31/03" the records display. Any suggestions...comments?
See SQL code below. Thanks,
Vince
SELECT DISTINCTROW ARLINH.Docno, ARLINH.Location, ARLINH.Custkey,
ARLINH.Itemkey, ARLINH.Unitprice, ARLINH.Ordqty, [Unitprice]*[Ordqty] AS
[Sale Amount], ARLINH.Docdate, ARLINH.Cost, [Sale Amount]-[Cost]*[Ordqty] AS
[Gross Profit]
FROM ARLINH
WHERE (((ARLINH.Docno)=[Document No]) AND ((ARLINH.Docdate)=[date]))
ORDER BY ARLINH.Docno;