What is wrong with this query?

For some reason no data is returned. Thanks for your help.

="SELECT REFTABLEID, REFRECID, NAME, NOTES, REFCOMPANYID, CREATEDDATE,
CustName, Accountnum, DATAAREAID, DIMENSION, DIMENSION2_, DIMENSION3_,
DIMENSION4_, DIMENSION5_ FROM Vw_Notes_Report" & IIF(Parameters!Cust.Value =
" ALL", " WHERE (CREATEDDATE >= " & Parameters!From.Value & ") AND
(CREATEDDATE <= " & Parameters!To.Value & ")", " WHERE (ACCOUNTNUM = '"
& Parameters!Cust.Value & "') AND (CREATEDDATE >= " & Parameters!From.Value
& ") AND (CREATEDDATE <= " & Parameters!To.Value & ")") & " ORDER BY
ACCOUNTNUM"

Lev
Tue Oct 05 00:41:51 CDT 2004

Try this regular query (not dynamic)

SELECT REFTABLEID, REFRECID, NAME, NOTES, REFCOMPANYID, CREATEDDATE,
CustName, Accountnum, DATAAREAID, DIMENSION, DIMENSION2_, DIMENSION3_,
DIMENSION4_, DIMENSION5_
FROM Vw_Notes_Report
WHERE (CREATEDDATE >= @From) AND (CREATEDDATE <= @To)
AND (( ACCOUNTNUM = @Cust) OR ( @Cust = 'ALL' ))
ORDER BY ACCOUNTNUM

If you prefer to use dynamic query, add textbox to your report and
copy/paste query expression into the textbox, so you can see what actual
query is.

--
This posting is provided "AS IS" with no warranties, and confers no rights.


"AshVsAOD" <.> wrote in message
news:uHIAalmqEHA.3324@TK2MSFTNGP15.phx.gbl...
> For some reason no data is returned. Thanks for your help.
>
> ="SELECT REFTABLEID, REFRECID, NAME, NOTES, REFCOMPANYID, CREATEDDATE,
> CustName, Accountnum, DATAAREAID, DIMENSION, DIMENSION2_, DIMENSION3_,
> DIMENSION4_, DIMENSION5_ FROM Vw_Notes_Report" & IIF(Parameters!Cust.Value
> =
> " ALL", " WHERE (CREATEDDATE >= " & Parameters!From.Value & ") AND
> (CREATEDDATE <= " & Parameters!To.Value & ")", " WHERE (ACCOUNTNUM =
> '"
> & Parameters!Cust.Value & "') AND (CREATEDDATE >= " &
> Parameters!From.Value
> & ") AND (CREATEDDATE <= " & Parameters!To.Value & ")") & " ORDER BY
> ACCOUNTNUM"
>
>

AshVsAOD
Tue Oct 05 20:15:15 CDT 2004

Thanks.
"Lev Semenets [MSFT]" <levs@microsoft.com> wrote in message
news:eSSVF4pqEHA.1816@TK2MSFTNGP09.phx.gbl...
> Try this regular query (not dynamic)
>
> SELECT REFTABLEID, REFRECID, NAME, NOTES, REFCOMPANYID, CREATEDDATE,
> CustName, Accountnum, DATAAREAID, DIMENSION, DIMENSION2_, DIMENSION3_,
> DIMENSION4_, DIMENSION5_
> FROM Vw_Notes_Report
> WHERE (CREATEDDATE >= @From) AND (CREATEDDATE <= @To)
> AND (( ACCOUNTNUM = @Cust) OR ( @Cust = 'ALL' ))
> ORDER BY ACCOUNTNUM
>
> If you prefer to use dynamic query, add textbox to your report and
> copy/paste query expression into the textbox, so you can see what actual
> query is.
>
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
>
> "AshVsAOD" <.> wrote in message
> news:uHIAalmqEHA.3324@TK2MSFTNGP15.phx.gbl...
> > For some reason no data is returned. Thanks for your help.
> >
> > ="SELECT REFTABLEID, REFRECID, NAME, NOTES, REFCOMPANYID,
CREATEDDATE,
> > CustName, Accountnum, DATAAREAID, DIMENSION, DIMENSION2_, DIMENSION3_,
> > DIMENSION4_, DIMENSION5_ FROM Vw_Notes_Report" &
IIF(Parameters!Cust.Value
> > =
> > " ALL", " WHERE (CREATEDDATE >= " & Parameters!From.Value & ") AND
> > (CREATEDDATE <= " & Parameters!To.Value & ")", " WHERE (ACCOUNTNUM =
> > '"
> > & Parameters!Cust.Value & "') AND (CREATEDDATE >= " &
> > Parameters!From.Value
> > & ") AND (CREATEDDATE <= " & Parameters!To.Value & ")") & " ORDER BY
> > ACCOUNTNUM"
> >
> >
>
>