Using criteria prompts in crosstab

  • Thread starter Thread starter Donna Brooks
  • Start date Start date
D

Donna Brooks

I have a crosstab query that I need the criteria to be
less than or equal whatever date I specify in the prompt.
I am trying to use <=[Enter the last day of the month]. I
have posted already and was told to use the declare my
parameters explicitly in the Parameters dialog box under
Query > Parameters...I have done this and it still
doesn't work. How does it know for what field I am trying
to specify criteria and can I use a criteria prompt in a
crosstab. Am I supposed to leave the criteria row blank
under the field I'm specifying for. Have never used a
crosstab query and don't know much about them. I just
know the date I need to use will change every month so I
need a way to prompt my user to put in the last day of
the following month and pull records with NextDateDue
before or on the day specified. Please help me....

TIA,
Donna Brooks
 
Donna said:
I have a crosstab query that I need the criteria to be
less than or equal whatever date I specify in the prompt.
I am trying to use <=[Enter the last day of the month]. I
have posted already and was told to use the declare my
parameters explicitly in the Parameters dialog box under
Query > Parameters...I have done this and it still
doesn't work. How does it know for what field I am trying
to specify criteria and can I use a criteria prompt in a
crosstab. Am I supposed to leave the criteria row blank
under the field I'm specifying for. Have never used a
crosstab query and don't know much about them. I just
know the date I need to use will change every month so I
need a way to prompt my user to put in the last day of
the following month and pull records with NextDateDue
before or on the day specified. Please help me....
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Open your cross-tab query in SQL view. Make sure there is a line like
this at the top of the query:

PARAMETERS [Enter the last date of the month] Date;
TRANSFORM ... etc. ...

Your WHERE clause should have a statement like this:

WHERE DateColumn <= [Enter the last date of the month] ... etc. ...

Change DateColumn to whatever is the name of your date column.

BTW, the phrase "Enter the last day of the month" encourages the user to
enter the month's day number. E.g.: October 31, 2004 - the user might
enter 31 as the last day of the month. Or the user may enter Thursday
instead of a number (or date). By using the word "date" in the phrase
you indicate that you want a date value and nothing else.

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

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

iQA/AwUBQHWcMoechKqOuFEgEQKbJwCfcAlqC9MzbjsBgzp+j4X8ECyGgnUAoMra
6SCDOihmV4xCnPmzALk9yzKl
=9fIn
-----END PGP SIGNATURE-----
 
Back
Top