Field not in Field List: What to do?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Jerry Crosby (jerry.crosby_at_interactministries.org)
Date: 11/17/04 

Date: Wed, 17 Nov 2004 17:03:00 GMT

I have a form based on a crosstab query. Occasionally, because of the way
crosstab queries work, a particular field may not appear in the final matrix
(because no data is contained in that "crosstab" location).

When that happens, I'll get an error in the field because that field is not
in the field list of the query.

What is the code/function/etc. for that field box on the form that would
say, "If this field doesn't exist in the field table, then just leave it
blank (and don't enter '#NAME?')"

Thanks in advance.

Jerry

Relevant Pages

  • Re: Dynamic Reporting based on Parameterized Crosstab Query
    ... Since the column headings are all dates at a regular interval, ... charge date charged hours are associated with. ... on the first 3 rowwise fields of the crosstab query. ...
    (microsoft.public.access.reports)
  • Re: Cross tab query construction with Subqueries
    ... I constructed a couple of sample Tables and a bunch of Queries based on them, to illustrate the use both of Crosstab Queries to display what I think you want, and of ordinary Select Queries that do the same kind of thing, though less concisely. ... It looks a bit like a Crosstab Query but is a bit lengthier. ... placing only one revenue source on a line. ...
    (microsoft.public.access.queries)
  • Re: Unbound Report
    ... Since your error message stated something about a crosstab, ... crosstab query as the error message suggested? ... > My subreport derives from qry_breast_adj_sum which has 1 ... > the same as our main report... ...
    (microsoft.public.access.reports)
  • Re: Rows from left to right
    ... Change to a Crosstab query. ... > Access adds Crosstab and Total rows to the grid. ... >the crosstab as the source for a report. ...
    (microsoft.public.access.reports)
  • Re: Parameters for a Report (HELP!)
    ... One of the resulting columns of your crosstab MUST be named Date. ... Duane Hookom ... the parameter crosstab query upon which the report is being based or some ... >> also for a report I am about to talk about) are pressed. ...
    (microsoft.public.access.reports)