Dan said:i have a crosstab query that runs off of a select query.
im trying to make the crosstab a pop up by doing between
[from] and [to] but it gives me an error message that the
microsoft engine database does not recognize can i not
do a pop up?
-----Original Message-----
Dan said:i have a crosstab query that runs off of a select query.
im trying to make the crosstab a pop up by doing between
[from] and [to] but it gives me an error message that the
microsoft engine database does not recognize can i not
do a pop up?
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
The words "from" and "to" are SQL keywords and are not recommended as
parameter names. If you mean a parameter prompt, then try this for your
SELECT query:
PARAMETERS [From ?] Date, [To ?] Date;
SELECT ...
FROM ...
WHERE DateColumn BETWEEN [From ?] And [To ?]
.... etc. ...
This assumes the From & To parameters are Date values. If they aren't,
change the PARAMETERS clause to match whatever data type they truly are.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQIWpu4echKqOuFEgEQISTwCeMmeptb0EAUhRc8Qr+mqy6PGK03 0AoLGC
7XfPfDQCmBpLdveFVuwuAGa/
=WezL
-----END PGP SIGNATURE-----
.
Im totally confused on what you are saying? Are you
telling me this to write in a sql query because its not
an sql query on any regular select query i could
always put in between [ ] and [ ] and it would prompt
me to put the date in. this is still the case but now it
seems with a crosstab i cant do this it never mattered
what i put in the [ ] [ ] from or to or whatever it
would didnt matter so im confused on what you are
saying is this something with xp we recently switched
to xp ive done this date range before no problems
-----Original Message-----
Dan wrote:
query.i have a crosstab query that runs off of a select
betweenim trying to make the crosstab a pop up by doing
the[from] and [to] but it gives me an error message that
notmicrosoft engine database does not recognize can i
do a pop up?
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
The words "from" and "to" are SQL keywords and are not
recommended as
parameter names. If you mean a parameter prompt, then
try this for your
SELECT query:
PARAMETERS [From ?] Date, [To ?] Date;
SELECT ...FROM ...WHERE DateColumn BETWEEN [From ?] And [To ?]
.... etc. ...
This assumes the From & To parameters are Date values.
If they aren't,
change the PARAMETERS clause to match whatever data type
they truly are.
-----Original Message-----
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I said [From] & [To] are not RECOMMENDED. I did not say unusable.
The reason I recommended that you put the PARAMETERS in the SELECT
query, that the cross-tab is based on, is because it is usually
easier/better to filter out any data you don't want from the source
before running the cross-tab. But, cross-tab queries can have a
PARAMETERS clause and those parameters can be used in the cross-tab
query.
Your first post did not quote the complete query error: "does not
recognize...." Does not recognize what?
It would be better if you just posted the SQL of the cross-tab and the
select query it is based on. Then we can see what you are working with.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQIbVQ4echKqOuFEgEQIBMACgkyaxRULzOvizd2gOJHGq+v7stH 4AnAii
jtUUP/MCRSTDOKPeSmWG7kdH
=9WVg
-----END PGP SIGNATURE-----
Im totally confused on what you are saying? Are you
telling me this to write in a sql query because its not
an sql query on any regular select query i could
always put in between [ ] and [ ] and it would prompt
me to put the date in. this is still the case but now it
seems with a crosstab i cant do this it never mattered
what i put in the [ ] [ ] from or to or whatever it
would didnt matter so im confused on what you are
saying is this something with xp we recently switched
to xp ive done this date range before no problems
-----Original Message-----
Dan wrote:
i have a crosstab query that runs off of a select
query.
im trying to make the crosstab a pop up by doing
between
[from] and [to] but it gives me an error message that
the
microsoft engine database does not recognize can i
not
do a pop up?
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
The words "from" and "to" are SQL keywords and are not
recommended as
parameter names. If you mean a parameter prompt, then
try this for your
SELECT query:
PARAMETERS [From ?] Date, [To ?] Date;
SELECT ...FROM ...WHERE DateColumn BETWEEN [From ?] And [To ?]
.... etc. ...
This assumes the From & To parameters are Date values.
If they aren't,
typechange the PARAMETERS clause to match whatever data
they truly are.
.
sorry i didnt mean to sound harsh. i tried putting the
parameters in the select query but that does not work
when i try to run the crosstab it gives me an error
message "microsoft jet database engine does not
recognize [ } as a valid field name or expression?
-----Original Message-----
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I said [From] & [To] are not RECOMMENDED. I did not say
unusable.
The reason I recommended that you put the PARAMETERS in
the SELECT
query, that the cross-tab is based on, is because it is
usually
easier/better to filter out any data you don't want from
the source
before running the cross-tab. But, cross-tab queries can
have a
PARAMETERS clause and those parameters can be used in the
cross-tab
query.
Your first post did not quote the complete query
error: "does not
recognize...." Does not recognize what?
It would be better if you just posted the SQL of the
cross-tab and the
select query it is based on. Then we can see what you
are working with.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQIbVQ4echKqOuFEgEQIBMACgkyaxRULzOvizd2gOJHGq+v7stH
4AnAii
jtUUP/MCRSTDOKPeSmWG7kdH
=9WVg
-----END PGP SIGNATURE-----
notIm totally confused on what you are saying? Are you
telling me this to write in a sql query because its
promptan sql query on any regular select query i could
always put in between [ ] and [ ] and it would
itme to put the date in. this is still the case but now
matteredseems with a crosstab i cant do this it never
itwhat i put in the [ ] [ ] from or to or whatever
switchedwould didnt matter so im confused on what you are
saying is this something with xp we recently
typeto xp ive done this date range before no problems
-----Original Message-----
Dan wrote:
i have a crosstab query that runs off of a select
query.
im trying to make the crosstab a pop up by doing
between
[from] and [to] but it gives me an error message that
the
microsoft engine database does not recognize can i
not
do a pop up?
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
The words "from" and "to" are SQL keywords and are not
recommended as
parameter names. If you mean a parameter prompt, then
try this for your
SELECT query:
PARAMETERS [From ?] Date, [To ?] Date;
SELECT ...
FROM ...
WHERE DateColumn BETWEEN [From ?] And [To ?]
.... etc. ...
This assumes the From & To parameters are Date values.
If they aren't,
change the PARAMETERS clause to match whatever data
they truly are.
.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Ah...
The combination of the square-bracket "[" and the curly-bracket "}"
seems to be causing the problem. If these are surrounding a table or
column name you must have square-brackets only. IOW, don't use the
curly-bracket.
If still having the problem it would help greatly to see the SQL you are
running (the one w/ the [ and } characters).
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQIbgioechKqOuFEgEQJIAgCghnIv/QhpJwgzRMDorbp4MVnJPkoAnj1M
5u5qXvpELMgoF6bID2B4VtVe
=ZVw5
-----END PGP SIGNATURE-----
sorry i didnt mean to sound harsh. i tried putting the
parameters in the select query but that does not work
when i try to run the crosstab it gives me an error
message "microsoft jet database engine does not
recognize [ } as a valid field name or expression?
-----Original Message-----
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I said [From] & [To] are not RECOMMENDED. I did not say
unusable.
The reason I recommended that you put the PARAMETERS in
the SELECT
query, that the cross-tab is based on, is because it is
usually
easier/better to filter out any data you don't want from
the source
before running the cross-tab. But, cross-tab queries can
have a
PARAMETERS clause and those parameters can be used in the
cross-tab
query.
Your first post did not quote the complete query
error: "does not
recognize...." Does not recognize what?
It would be better if you just posted the SQL of the
cross-tab and the
select query it is based on. Then we can see what you
are working with.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQIbVQ4echKqOuFEgEQIBMACgkyaxRULzOvizd2gOJHGq+v7stH
4AnAii
jtUUP/MCRSTDOKPeSmWG7kdH
=9WVg
-----END PGP SIGNATURE-----
Dan wrote:
Im totally confused on what you are saying? Are you
telling me this to write in a sql query because its
not
an sql query on any regular select query i could
always put in between [ ] and [ ] and it would
prompt
me to put the date in. this is still the case but now
it
seems with a crosstab i cant do this it never
mattered
what i put in the [ ] [ ] from or to or whatever
it
would didnt matter so im confused on what you are
saying is this something with xp we recently
switched
to xp ive done this date range before no problems
-----Original Message-----
Dan wrote:
i have a crosstab query that runs off of a select
query.
im trying to make the crosstab a pop up by doing
between
[from] and [to] but it gives me an error message that
the
microsoft engine database does not recognize can i
not
do a pop up?
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
The words "from" and "to" are SQL keywords and are not
recommended as
parameter names. If you mean a parameter prompt, then
try this for your
SELECT query:
PARAMETERS [From ?] Date, [To ?] Date;
SELECT ...
FROM ...
WHERE DateColumn BETWEEN [From ?] And [To ?]
.... etc. ...
This assumes the From & To parameters are Date values.
If they aren't,
change the PARAMETERS clause to match whatever data
type
they truly are.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
.
-----Original Message-----
Pardon me for jumping in.
First thing, with a crosstab query you MUST declare your parameters and if any
other queries are used in the crosstab their parameters must also be declared.
Open the query in design mode
Select Query: Parameters from the Menu
Fill in the EXACT name of the parameter(s) in column 1
Select the data type of the parameter(s) in column 2
iQA/AwUBQIbgioechKqOuFEgEQJIAgCghnIv/QhpJwgzRMDorbp4MVnJPko-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Ah...
The combination of the square-bracket "[" and the curly- bracket "}"
seems to be causing the problem. If these are surrounding a table or
column name you must have square-brackets only. IOW, don't use the
curly-bracket.
If still having the problem it would help greatly to see the SQL you are
running (the one w/ the [ and } characters).
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
Anj1M.5u5qXvpELMgoF6bID2B4VtVe
=ZVw5
-----END PGP SIGNATURE-----
sorry i didnt mean to sound harsh. i tried putting the
parameters in the select query but that does not work
when i try to run the crosstab it gives me an error
message "microsoft jet database engine does not
recognize [ } as a valid field name or expression?
-----Original Message-----
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I said [From] & [To] are not RECOMMENDED. I did not say
unusable.
The reason I recommended that you put the PARAMETERS in
the SELECT
query, that the cross-tab is based on, is because it is
usually
easier/better to filter out any data you don't want from
the source
before running the cross-tab. But, cross-tab queries can
have a
PARAMETERS clause and those parameters can be used in the
cross-tab
query.
Your first post did not quote the complete query
error: "does not
recognize...." Does not recognize what?
It would be better if you just posted the SQL of the
cross-tab and the
select query it is based on. Then we can see what you
are working with.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQIbVQ4echKqOuFEgEQIBMACgkyaxRULzOvizd2gOJHGq+v7st H4AnAii
jtUUP/MCRSTDOKPeSmWG7kdH
=9WVg
-----END PGP SIGNATURE-----
Dan wrote:
Im totally confused on what you are saying? Are you
telling me this to write in a sql query because its
not
an sql query on any regular select query i could
always put in between [ ] and [ ] and it would
prompt
me to put the date in. this is still the case but now
it
seems with a crosstab i cant do this it never
mattered
what i put in the [ ] [ ] from or to or whatever
it
would didnt matter so im confused on what you are
saying is this something with xp we recently
switched
to xp ive done this date range before no problems
-----Original Message-----
Dan wrote:
i have a crosstab query that runs off of a select
query.
im trying to make the crosstab a pop up by doing
between
[from] and [to] but it gives me an error message that
the
microsoft engine database does not recognize can i
not
do a pop up?
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
The words "from" and "to" are SQL keywords and are not
recommended as
parameter names. If you mean a parameter prompt, then
try this for your
SELECT query:
PARAMETERS [From ?] Date, [To ?] Date;
SELECT ...
FROM ...
WHERE DateColumn BETWEEN [From ?] And [To ?]
.... etc. ...
This assumes the From & To parameters are Date values.
If they aren't,
change the PARAMETERS clause to match whatever data
type
they truly are.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
.
i can get the parameter to work in the select query, but
not the crosstab i tried putting the parameters in both
the select and crosstab but i still get the same error
message i dont know ?-----Original Message-----
Pardon me for jumping in.
First thing, with a crosstab query you MUST declare your parameters and if any
other queries are used in the crosstab their parameters must also be declared.
Open the query in design mode
Select Query: Parameters from the Menu
Fill in the EXACT name of the parameter(s) in column 1
Select the data type of the parameter(s) in column 2
iQA/AwUBQIbgioechKqOuFEgEQJIAgCghnIv/QhpJwgzRMDorbp4MVnJPko-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Ah...
The combination of the square-bracket "[" and the curly- bracket "}"
seems to be causing the problem. If these are surrounding a table or
column name you must have square-brackets only. IOW, don't use the
curly-bracket.
If still having the problem it would help greatly to see the SQL you are
running (the one w/ the [ and } characters).
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
Anj1M.5u5qXvpELMgoF6bID2B4VtVe
=ZVw5
-----END PGP SIGNATURE-----
Dan wrote:
sorry i didnt mean to sound harsh. i tried putting the
parameters in the select query but that does not work
when i try to run the crosstab it gives me an error
message "microsoft jet database engine does not
recognize [ } as a valid field name or expression?
-----Original Message-----
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I said [From] & [To] are not RECOMMENDED. I did not say
unusable.
The reason I recommended that you put the PARAMETERS in
the SELECT
query, that the cross-tab is based on, is because it is
usually
easier/better to filter out any data you don't want from
the source
before running the cross-tab. But, cross-tab queries can
have a
PARAMETERS clause and those parameters can be used in the
cross-tab
query.
Your first post did not quote the complete query
error: "does not
recognize...." Does not recognize what?
It would be better if you just posted the SQL of the
cross-tab and the
select query it is based on. Then we can see what you
are working with.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQIbVQ4echKqOuFEgEQIBMACgkyaxRULzOvizd2gOJHGq+v7st H
4AnAii
jtUUP/MCRSTDOKPeSmWG7kdH
=9WVg
-----END PGP SIGNATURE-----
Dan wrote:
Im totally confused on what you are saying? Are you
telling me this to write in a sql query because its
not
an sql query on any regular select query i could
always put in between [ ] and [ ] and it would
prompt
me to put the date in. this is still the case but now
it
seems with a crosstab i cant do this it never
mattered
what i put in the [ ] [ ] from or to or whatever
it
would didnt matter so im confused on what you are
saying is this something with xp we recently
switched
to xp ive done this date range before no problems
-----Original Message-----
Dan wrote:
i have a crosstab query that runs off of a select
query.
im trying to make the crosstab a pop up by doing
between
[from] and [to] but it gives me an error message that
the
microsoft engine database does not recognize can i
not
do a pop up?
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
The words "from" and "to" are SQL keywords and are not
recommended as
parameter names. If you mean a parameter prompt, then
try this for your
SELECT query:
PARAMETERS [From ?] Date, [To ?] Date;
SELECT ...
FROM ...
WHERE DateColumn BETWEEN [From ?] And [To ?]
.... etc. ...
This assumes the From & To parameters are Date values.
If they aren't,
change the PARAMETERS clause to match whatever data
type
they truly are.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
.