sorting or grouping

G

Graveyardblues

I have a Report that list a number of Address's...I would like to sort or
group them by even #'s & Odd #'s.... Would love to just do it in the report
??? Is there any way to format the report so it will print / show all Even #
address's, Followed by all Odd adress's ???

Thanks for any Help....

Aaron
 
J

John Spencer

=Val("0" & [Address]) Mod 2

Adding the zero character to the start of the address, will handle addresses
that don't start with a numeric character
 
G

Graveyardblues

Would this go on the Report ???
I tried to put this into "Filter" on the report, Turn Filter to "On", but
did not seem to seperate the Odd / Even....
Would I need to put this into a Query ???
Thanks for your help..

Aaron

John Spencer said:
=Val("0" & [Address]) Mod 2

Adding the zero character to the start of the address, will handle addresses
that don't start with a numeric character


Graveyardblues said:
I have a Report that list a number of Address's...I would like to sort or
group them by even #'s & Odd #'s.... Would love to just do it in the
report
??? Is there any way to format the report so it will print / show all
Even #
address's, Followed by all Odd adress's ???

Thanks for any Help....

Aaron
Click to expand...
Click to expand...
 
M

Marshall Barton

Graveyardblues said:
I have a Report that list a number of Address's...I would like to sort or
group them by even #'s & Odd #'s.... Would love to just do it in the report
??? Is there any way to format the report so it will print / show all Even #
address's, Followed by all Odd adress's ???
Click to expand...


In general, addresses are not well enough defined to figure
out what's even or odd. If your set of addresses is
**always** nnn street, then you set the report's Sorting and
Grouping (View menu) to the expression:
=Val(address) Mod 2
 
G

Graveyardblues

That works !!!! Can I now get the report to break at the end of the Odd's &
start a new page at the beginning of the Even's ??? Could I runa Query that
would accomplish the same by seperating Odd & Even in the Query ???

Any Help is greatly appreciated !!!!

Aaron
 
M

Marshall Barton

Add a group header section for the group (make it very small
if you have no other use for it). Then set the header
section's ForceNewPage property to Before Section.
 
J

John Spencer

You could put this in the query and then sort on it in the report.

IMPORTANT:
The sort order in a report is controlled by the SORTING AND GROUPING
(Menubar: View : Sorting and Grouping) that is set in the report. If you
don't set the sort order by this dialog, then Access may or may not return
the records in the order you've specified in the query. Access reports
IGNORE the order clause in the query.

Graveyardblues said:
Would this go on the Report ???
I tried to put this into "Filter" on the report, Turn Filter to "On", but
did not seem to seperate the Odd / Even....
Would I need to put this into a Query ???
Thanks for your help..

Aaron

John Spencer said:
=Val("0" & [Address]) Mod 2

Adding the zero character to the start of the address, will handle
addresses
that don't start with a numeric character


message
I have a Report that list a number of Address's...I would like to sort
or
group them by even #'s & Odd #'s.... Would love to just do it in the
report
??? Is there any way to format the report so it will print / show all
Even #
address's, Followed by all Odd adress's ???

Thanks for any Help....

Aaron
Click to expand...
Click to expand...
Click to expand...
 
Top