how to generate a report from Form output

[var]

Hi

i have a form which runs a cross tab query, when i tried to generate a
report using wizard it doesn't show any fields(left hand side box,
where you can select the needed fields for final headings in a report)
.........i have no idea why this has happening?!!

more over i am new to Access and unable to figure it out myself, is
there anyway that i can produce a desired report for my form output (my
query runs very fine)

anyhelp would be greatly appreciated

thanks
var

 

[Duane Hookom]

You may need to enter all possible column heading values into the Column
Headings property of the crosstab query.

 

[var]

Hi Hookom,

yaa tried to include most the column headings in crosstab query but
there are some heading which need to be mentioned as Count and some
other as Sum.....

since i am really new to Access and SQL .......i have no idea how to
make out a report with these elements, i tried to create a plain
report and source the output in the desired fields, may be my
Expression skills are not that good enough to re generate the desired
output......and it seems to be that i need write a VB code for each
field to recall the rersults from the query output! (where i am not
good yet)

i learned many things from this group and able to create a query which
successfully run and gives the desired results but the report make up
part is still not in a good way...............is there anything that
you can help me out to accomplish this task

var

 

[Duane Hookom]

I'm not sure what you mean by "some heading which need to be mentioned as
Count and...".
A crosstab query has a Column Headings property. Did you find it? Do you
understand what to enter into this property?

You should hardly ever need to write any code to create sums or counts or
whatever.

 

[var]

Hi Hookom,

i am not sure what you are suggesting but can you pls me give some
references and guide me in this regard

var

 

[Duane Hookom]

Here is my original reply:
You may need to enter all possible column heading values into the Column
Headings property of the crosstab query.

To find the Column Headings property, open your crosstab in design view and
select View->Properties.