Re: Crosstab error

From: Joan Wild (jwild_at_nospamtyenet.com)
Date: 04/29/04 

Date: Thu, 29 Apr 2004 13:56:21 -0400

George Schneider wrote:
> I have a form where you select the category. In the main query I
> have the criteria for the category field set to
> [Forms]![Main]![Combo0]. This works fine in the main query. I'm
> trying to create a crosstab query with this category filed as a value
> for one of the rows and get an error saying the microsoft jet
> database engine does not reconizw forms!main!combo0 as a valid field
> name. Why is this.

Crosstab queries insist on parameters being defined. Go into Query,
Parameters and put in your parameter exactly as it appears in your criteria,
and specify the datatype. 

-- 
Joan Wild
Microsoft Access MVP

Relevant Pages

  • Re: Adding half year or 2 quaters
    ... Create a query. ... put the following as the criteria for the date field (assuming you're ... Doug Steele, Microsoft Access MVP ... You can create a form that uses the query above as its recordsource, ...
    (microsoft.public.access.formscoding)
  • Re: providing an any option within a combo box
    ... criteria for a query, you'll need to ensure that you handle that new option ... Assuming you've got Forms!NameOfForm!NameOfCombo as a criteria in your ... Doug Steele, Microsoft Access MVP ... but others may not be specified and so an 'any' selection will not rule ...
    (microsoft.public.access.gettingstarted)
  • Re: Filtering on a VB function return value
    ... Microsoft Access MVP 2006 ... However, if I try to place a value in the criteria portion of the query, such as TRUE, I get a message that it has an incompatible data type. ... In addition, if I run the query without the criteria, and then right-click on the field and select either Filter by Selection or Filter Excluding Selection, I get the same error message. ...
    (microsoft.public.access.queries)
  • Re: Multi select box Query problem
    ... as the criteria (although you'd be better off, in my opinion, joining ... Doug Steele, Microsoft Access MVP ... However when I enter the syntax in to the query criteria... ...
    (microsoft.public.access.formscoding)
  • Re: embed a query into a form that has the query criteria
    ... Steve Schapel, Microsoft Access MVP ... You will notice after you close and save the query, if you open it again in design view you will see that Access has re-organised the criteria to suit its own purposes - that's ok. ...
    (microsoft.public.access.forms)