How do I set up Date query in a crosstab query?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have set up a crosstab query that works fine.
I now want to have the user enter the beginning and ending dates for this
query.
I am unable to make this work.
Does anyone know how to make this work?
 
Make sure you set the query parameter data types. Menu select
Query->Parameters and enter your parameters and types.
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Template like this:

PARAMETERS BeginningDate Date, EndingDate Date;
TRANSFORM ...
SELECT ...
FROM ...
WHERE Date_column BETWEEN BeginningDate And EndingDate
GROUP BY ...
PIVOT ..

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQVRzeYechKqOuFEgEQKjjACg4qWPMLLfrxlINIrLxXL7sL6KsNYAn0Oq
SoTgNgSALDJKXoVGMFuk5jm6
=U1qn
-----END PGP SIGNATURE-----
 
Back
Top