Thanks, Havent got it quite right yet: SEE BELOW
--- In ms_access@yahoogroups.com, "John Viescas" <[EMAIL PROTECTED]> wrote: > You can use a parameter in a crosstab, but you must explicity declare it > (Parameters on the Query menu in design view). CAN YOU GIVE ME MORE? SAY ,AN EXAMPLE OF WHAT TO PUT IN THE PARAMETER BOX AND THE CROSSTAB QUERY (WHERE IN DESIGN VIEW ) If you want a paramter > selected from a combo box, you must design a form with a combo box that > stays open when you open the query. THINK IVE DONE THAT WITH "OPEN FORM..'" IN THE MACRO The parameter in the query would then > be in the form: [Forms]![MyParmForm]![cmbValue] .. where "MyForm" is the > name of the form and "cmbValue" is the name of the combo box. WHERE DO I PUT THIS STATEMENT? SORRY FOR BEING SUCH A DUMB ASS!!! > > John Viescas, author > "Building Microsoft Access Applications" > "Microsoft Office Access 2003 Inside Out" > "Running Microsoft Access 2000" > "SQL Queries for Mere Mortals" > http://www.viescas.com/ > > > -----Original Message----- > > From: alitis48 [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, March 30, 2005 3:21 AM > > To: ms_access@yahoogroups.com > > Subject: [ms_access] crosstab query > > > > > > > > > > Is it possible to use a combo list(from a table) to input criteria > > into a crosstab query? If so what is syntax of the > > expression? I tried > > Select [.....].....From [....]; but no luck. If not what's the > > alternative? > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
