Field name not recognized

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm still trying to learn Access and apologize in advance if I haven’t
provided enough information or clearly explained myself.

I have a report that runs off a crosstab query. It works fine so long as
there is at least one selection of each option within an option group. The
field name for the option group is Status and the options are 1 (Approved), 2
(Denied), and 3 (Withdrawn). The report has a text box for each status with
the control source set to 1, 2, and 3. However say there were no denials
during a specific period the report is run for I get an error, “…does not
recognize [2] as a valid field name or expression.†I figure I’m getting
this since there were no denials for that time period so the control source
no longer appears in the field list (other than that I don't have a clue).
Is there a way to run the report and just leave the denied status blank?

Thanks in advance.
 
Robin,
Rather than reinvent the wheel... try a Google Groups search in the
Access groups
http://groups.google.com/groups/dir?hl=en&sel=33606877&expand=1
under "access" "dynamic crosstab".
There are many explanations, links, and sample files dealing with
dynamic crosstabs.

Here's one from Duane Hookum... Access MVP (10/4/2002)
There are a couple sample mdbs in the Crosstab Report download at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. One of these creates
dynamic headings for a crosstab report. You design your report for a set
number of columns and if the crosstab generates more than the set number,
the extra columns wrap under the first set. All column headings and control
sources are set automatically. The method used is much faster and more
flexible than the one proposed in the Solutions.mdb. It also use significant
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
less code.
 
Back
Top