R
ryguy7272
I found a few articles online that said a persona can use a parameter inside
of a crosstab query, so I know it can be done, but I can’t figure out how to
do it for my specific query. I guess it is run from a Form, right.
I have a Form named ‘frmExport’ that runs a couple dozen macros to make sure
all queries are updated before three queries (which get all information from
these other queries) are exported as Excel spreadsheets. How can I pass a
parameter to the this one query (SQL below) when this specific query is
called by the Macro and updated?
TRANSFORM Sum(tblJolly.Revenue) AS SumOfRevenue
SELECT tblVP_Mapping.VP, tblVP_Mapping.[Sales Rep], tblJolly.[Related
Company], tblJolly.Company, tblJolly.Opportunity, "N" AS Quarter
FROM tblJolly INNER JOIN tblVP_Mapping ON tblJolly.[Sales Rep] =
tblVP_Mapping.[JOLIET ID]
WHERE (((tblJolly.Period) Between #7/1/2008# And #9/30/2008#))
GROUP BY tblVP_Mapping.VP, tblVP_Mapping.[Sales Rep], tblJolly.[Related
Company], tblJolly.Company, tblJolly.Opportunity, "N"
PIVOT tblJolly.InventoryType;
Regards,
Ryan---
of a crosstab query, so I know it can be done, but I can’t figure out how to
do it for my specific query. I guess it is run from a Form, right.
I have a Form named ‘frmExport’ that runs a couple dozen macros to make sure
all queries are updated before three queries (which get all information from
these other queries) are exported as Excel spreadsheets. How can I pass a
parameter to the this one query (SQL below) when this specific query is
called by the Macro and updated?
TRANSFORM Sum(tblJolly.Revenue) AS SumOfRevenue
SELECT tblVP_Mapping.VP, tblVP_Mapping.[Sales Rep], tblJolly.[Related
Company], tblJolly.Company, tblJolly.Opportunity, "N" AS Quarter
FROM tblJolly INNER JOIN tblVP_Mapping ON tblJolly.[Sales Rep] =
tblVP_Mapping.[JOLIET ID]
WHERE (((tblJolly.Period) Between #7/1/2008# And #9/30/2008#))
GROUP BY tblVP_Mapping.VP, tblVP_Mapping.[Sales Rep], tblJolly.[Related
Company], tblJolly.Company, tblJolly.Opportunity, "N"
PIVOT tblJolly.InventoryType;
Regards,
Ryan---