Re: query to create fields

From: George Nicholson (JunkGeorgeN_at_msn.com)
Date: 06/29/04 

Date: Tue, 29 Jun 2004 16:33:37 -0500

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. 

-- 
George Nicholson
Remove 'Junk' from return address.
"tony wong" <x34@hknet.com> wrote in message
news:Of6y3xhXEHA.1000@TK2MSFTNGP12.phx.gbl...
> 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.
>
>

Relevant Pages

  • Re: Adding blank lines in a report
    ... table that tells Access about the missing numbers. ... Create a query that contains both this table and the table containing ... Drag tblCount.CountID into the output grid. ... and use it as the RecordSource for your report. ...
    (microsoft.public.access.reports)
  • Re: Interesting form design problem: help!
    ... open in design view, click View> Sorting and Grouping (or click the toolbar ... records in a report". ... I thought it might be easier if I use a query instead then I can filter ... When I go through the wizard I choose these fields. ...
    (microsoft.public.access.forms)
  • Re: "0.0" Value (not Null)... missing value in report
    ... If you open your table in design view, what data type are Sale_Price, SPC, and B_D_Option_Grp? ... Assuming they are all either Number or Currency, then I don't see any way Access could be misunderstanding the data type in the query. ... I will assume so, which leads us to conclude that the query is now fine, so the problem is with the report. ... 'CalculationChecker' report but produces a blank on my application report ...
    (microsoft.public.access.reports)
  • Re: first attempt at a report - HELP!
    ... Create a new query containing both tblDate and your other table. ... In the upper pane of the query design window, ... Drag TheDate from tblDate into the query. ... Now to use the query in the report. ...
    (microsoft.public.access.reports)
  • Re: Report shows null values, how to convert to a zero
    ... Open the report in design view, and set the Format property of this text box ... the query in SQL View, and add Nzaround the ... TRANSFORM SumAS SumOfQuantity ...
    (microsoft.public.access.reports)