accommodating missing field data in x-tab report

  • Thread starter Thread starter Carol B
  • Start date Start date
C

Carol B

I have created a crosstab query and would like to output
the results in a report. The rows are Names, and the
column headings are a field called Year, where each value
might be an individual year such 1920, 1930, 1940 etc.

The table which was the source for the crosstab query,
containing the individual records, is still being
updated. Therefore, a specific individual year might not
be included yet for any Name in this table. In this
example, assume that I have no records with 1930 in the
field Year.

I would like to have the report show all the years (1920,
1930, 1940) as column headings, even though I don't have
anything entered yet showing 1930. While I can create
such a report in Design view, when I try to display the
report I get an error message saying that the Jet engine
can't find 1930.

(Report format):
1920 1930 1940
Name1 x
Name2 x x
Name3

How do I work around this so I can still view the
report? Thanks, ~Carol
 
Open the query in design view.
Open the Properties box (View menu).
In the properties of the query, you can specify the Column Headings, e.g.:
1920, 1930, 1940, ...
 
Hi Allen, that worked great! Thanks, Carol
-----Original Message-----
Open the query in design view.
Open the Properties box (View menu).
In the properties of the query, you can specify the Column Headings, e.g.:
1920, 1930, 1940, ...

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.




.
Click to expand...
 
Back
Top