View Single Post
  #1  
Old May 10th, 2010, 07:30 PM posted to microsoft.public.access.queries
gator
external usenet poster
 
Posts: 166
Default crosstab parameterized query

PARAMETERS FISCALMO IEEESingle;
SELECT *
FROM [01-GL History Query]
WHERE ((([01-GL History Query].TYPE)=3) AND (([01-GL History Query].YRMODA)
Like "10*"))
ORDER BY [01-GL History Query].AMOUNT;

There is my query where I finally got the parameter fixed where FISCALMO
would prompt for the month. The crosstab isn't picking up the other
"explicitly" stated criteria. For the FISCALMO to work I had to remove the
parameter from the criteria pane in the query "designer" and declare it in
the "Parameters" section from the menu bar. Can a parameter be "explicitly"
stated for a crosstab? If so, how? Or do all criteria for a crosstab need
to be parameterized in the same manner as the FISCALMO?