Re: crosstab query

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Try putting LIKE in front of the expression.

LIKE IIF(...)

or enter the following as the criteria
Field: Whatever
Criteria: [Forms]![Form Name]![Combo7] or [Forms]![Form Name]![Combo7] Is
Null

In the SQL statement that would be

WHERE Whatever = [Forms]![Form Name]![Combo7] or [Forms]![Form
Name]![Combo7] Is Null

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"alm09" <alm09@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:61B67618-07D9-493C-BF52-B2316DC6BB82@xxxxxxxxxxxxxxxx
I want a crosstab query to return all records unless the user specifies a
particular account number by updating a combo box on a form. The criteria
I
have in the crosstab query is as follows:

IIf(IsNull([Forms]![Form Name]![Combo7]),"*",[Forms]![Form Name]![Combo7])

When I input an acct number using the combo box the query works and
returns
only those related records. When I leave the combo box null (i.e. do not
update it) and want all records returned I get zero records returned,
when,
in fact, I am expecting thousands of records.

Any suggestions?



.

Relevant Pages

  • Re: Criteria Expression in a Crosstab Query Column Heading
    ... "Duane Hookom" wrote: ... I have a column heading in my crosstab query that is Date. ... >> am trying to do an expression in my Criteria so I can select a date range. ...
    (microsoft.public.access.queries)
  • RE: results of queries dont match
    ... "Bryan W.H." ... > do this I started adding criteria to peel away layers of information until i ... It looked like I was missing data in my table. ... > The Criteria in the simple query is the exact same as in the crosstab query. ...
    (microsoft.public.access.queries)
  • RE: Use crosstab column heading in a calculation
    ... The main form is open in form view and qryParameters runs perfectly using the ... But any crosstab query I design, ... criteria or uses a query that contains the criteria, ... >GROUP BY SpotMonth, Float, sigma ...
    (microsoft.public.access.queries)
  • Using criteria prompts in crosstab
    ... I have a crosstab query that I need the criteria to be ... less than or equal whatever date I specify in the prompt. ...
    (microsoft.public.access.queries)
  • Re: Criteria Expression in a Crosstab Query Column Heading
    ... >I have created a crosstab query that calculates the sum of points by dates ... I have a column heading in my crosstab query that is Date. ... > am trying to do an expression in my Criteria so I can select a date range. ...
    (microsoft.public.access.queries)