criteria issue

[Michel Walsh]

You should add a text box at the right group footer, not page footer. Again,
you can let the Report Wizard do it for you, with a new report. Name the
text box by something ELSE than an existing field name, and, in its control
source, type:

=SUM(OrderQty)




The irregular line spacing may be due that you have an empty record, or that
you print some group footer, or group header, with nothing in it, and what
you see is just the paper space it consumes, even if there is no control in
its section.



Vanderghast, Access MVP

one last thing....how can add all this numbers.......i know it's a =sum()
at
the report footer, but what expression, this =sum(OrderQty) has no name
and
when i give it a name, it gives me and error when i try to add it..in the
report footer.....thanks again.

Hey Michel,
thanks for your help, you have been soooo patient with me and love
that....
thanks again....
one more question....why the result come with different spacing between
them.

e.g...

result1

result2

result3
result4

thanks again for your help...you the best

The ordering defined in the query WON'T be considered in the report
unless
you do it specifically (same properties sheet, "SORTING and grouping").
So,

[quoted text clipped - 10 lines]

you
think.....? thanks again.

 

[bigwillno2 via AccessMonster.com]

I got it, you was a great help, Michel, i which everyone was like you...with
patience....man......i got it working thanks again......

You should add a text box at the right group footer, not page footer. Again,
you can let the Report Wizard do it for you, with a new report. Name the
text box by something ELSE than an existing field name, and, in its control
source, type:

=SUM(OrderQty)

The irregular line spacing may be due that you have an empty record, or that
you print some group footer, or group header, with nothing in it, and what
you see is just the paper space it consumes, even if there is no control in
its section.

Vanderghast, Access MVP

one last thing....how can add all this numbers.......i know it's a =sum()
at

[quoted text clipped - 28 lines]

 

[bigwillno2 via AccessMonster.com]

Hey Michel,

sorry to bother you again, but i got a little issue with that footer section..
..
it's not coming up in a export that i have to do to an excel sheet......do
you happen to know why it's doing that.....it's exporting the other stuff on
the report but that section...that new group footer that you helped me with...
i hope you could help with this. thanks...

I got it, you was a great help, Michel, i which everyone was like you...with
patience....man......i got it working thanks again......

You should add a text box at the right group footer, not page footer. Again,
you can let the Report Wizard do it for you, with a new report. Name the

[quoted text clipped - 15 lines]

 

[Michel Walsh]

Well, that is because a report is not really meant to be 'exported' (unless
you mean something like exported into a pdf 'file').

You have to go back to a query, and use DoCmd.TransferXXX (or equivalent).
The query can then have the criteria inside it, in its WHERE clause, and can
be a Group By query (also called a Total query) so you can SUM or use any
relevant aggregate.


Vanderghast, Access MVP

Hey Michel,

sorry to bother you again, but i got a little issue with that footer
section..
.
it's not coming up in a export that i have to do to an excel sheet......do
you happen to know why it's doing that.....it's exporting the other stuff
on
the report but that section...that new group footer that you helped me
with...
i hope you could help with this. thanks...

I got it, you was a great help, Michel, i which everyone was like
you...with
patience....man......i got it working thanks again......

You should add a text box at the right group footer, not page footer.
Again,
you can let the Report Wizard do it for you, with a new report. Name the

[quoted text clipped - 15 lines]

you
think.....? thanks again.

 

[bigwillno2 via AccessMonster.com]

Hey Michel,

it works fine now, thanks a lot.........i had to go back to the grouping
thing and have the header show up, head does export it and does everything
else the footer does. thanks.....again

Well, that is because a report is not really meant to be 'exported' (unless
you mean something like exported into a pdf 'file').

You have to go back to a query, and use DoCmd.TransferXXX (or equivalent).
The query can then have the criteria inside it, in its WHERE clause, and can
be a Group By query (also called a Total query) so you can SUM or use any
relevant aggregate.

Vanderghast, Access MVP

Hey Michel,

[quoted text clipped - 18 lines]