Very Computer

MS Access Query:
SELECT tblInvoice.InvoiceNo, tblCharge.CktCode,
tblCharge.ChargeType, tblCharge.Description,
tblCharge.UnitRate, tblCharge.Units, tblCharge.Time,
tlkpChargeType.ChargeType AS TblChgTypeChargeType
FROM (tlkpChargeClass INNER JOIN tlkpChargeType ON
tlkpChargeClass.ChargeClass = tlkpChargeType.ChargeClass)
INNER JOIN (((tblBAN INNER JOIN (tblASR INNER JOIN
tblCircuit ON tblASR.ASRID = tblCircuit.ASRID) ON
tblBAN.BAN = tblASR.BAN) INNER JOIN tblInvoice ON
tblBAN.BAN = tblInvoice.BAN) INNER JOIN tblCharge ON
tblCircuit.CktCode = tblCharge.CktCode) ON
tlkpChargeType.ChargeType = tblCharge.ChargeType;
WHERE (((tblCircuit.ActiveDt)<=[forms]!
[frmInvoiceProcessing].[ocxCal]) AND
((tblCircuit.DisconnectDt) Is Null Or
(tblCircuit.DisconnectDt)>DateAdd("m",-1,[forms]!
[frmInvoiceProcessing]![ocxCal])));

Thanks,
C.R.Amaran

I rebuild a form-driven query like yours in Access2002.

SELECT dbo_TESTTABLE.FIELD_A, dbo_TESTTABLE.FIELD_B FROM dbo_CARMODEL
WHERE (((dbo_TESTTABLE.FIELD_A)=Val(Forms!Formular1!txtQueryInput)));
It worked fine! Look out for the "!" after "forms". Access is very
restrictive on that.

Good Luck, Jens

Quote:> Hi,
>   My MS Access Query uses Forms. Please let me know what
> is the equivalent MS SQL Query. The problem is in the
> WHERE statement.

> MS Access Query:
> SELECT tblInvoice.InvoiceNo, tblCharge.CktCode,
> tblCharge.ChargeType, tblCharge.Description,
> tblCharge.UnitRate, tblCharge.Units, tblCharge.Time,
> tlkpChargeType.ChargeType AS TblChgTypeChargeType
> FROM (tlkpChargeClass INNER JOIN tlkpChargeType ON
> tlkpChargeClass.ChargeClass = tlkpChargeType.ChargeClass)
> INNER JOIN (((tblBAN INNER JOIN (tblASR INNER JOIN
> tblCircuit ON tblASR.ASRID = tblCircuit.ASRID) ON
> tblBAN.BAN = tblASR.BAN) INNER JOIN tblInvoice ON
> tblBAN.BAN = tblInvoice.BAN) INNER JOIN tblCharge ON
> tblCircuit.CktCode = tblCharge.CktCode) ON
> tlkpChargeType.ChargeType = tblCharge.ChargeType;
> WHERE (((tblCircuit.ActiveDt)<=[forms]!
> [frmInvoiceProcessing].[ocxCal]) AND
> ((tblCircuit.DisconnectDt) Is Null Or
> (tblCircuit.DisconnectDt)>DateAdd("m",-1,[forms]!
> [frmInvoiceProcessing]![ocxCal])));

> Thanks,
> C.R.Amaran