query to create fields

  • Thread starter Thread starter tony wong
  • Start date Start date
T

tony wong

i have a cross table query to create fields (A, B, C & D) in table I.

then I used field A, B, C & D in table I to generate report.

But sometimes there is no A value when generating table I, then table I only
has A, B & C.

then it would have error when generating report from table I because of
missing value of A.

How can i solve it by having A, B, C, D fields when generating table I?

Thanks a lot.
 
With the Crosstab query open in Design view, View>Properties: Set the
ColumnHeadings property to "A", "B", "C", "D".
The query will then always generate those columns, even if there is no data
for them and your report will be happy.
 
Two ways:

1) Change the column headings property to inlcude those
fields.
2) Create a table that has the fields you want and do a
left join against that table.

I like the latter approach better as it makes the data
more accessible to users who may not know queries too well
and it looks cleaner too.

-Mark
 
Back
Top