2 challenges - page borders / group, yes, but with label?

I need to have a 8 1/2x11" sheet of paper accommodate several, say, +/- 3in
x 4in "reports". I was given the great advice of setting a page to print
x-number of reports per page, or whatever, but this hasn't really worked
out. Difficult to know what to start with to get the target dimensions in
the finished "reports" g.

I hit upon building a custom "label" that I could use instead of the
standard page sizes and this has worked really well. But I'm stuck with 2
things - no lines as cutting guides and how to group by alphabet?

1) Re the cutting guides - is there a way to put borders around each label
similar to what Word can do so that each "label" has a border? Yes, I could
position everything so that I'd just cut up the sheet into 8ths or whatever,
but it would be so much easier to have a precisely-defined, unchanging size
via borders. I won't always have a paper cutter handy g.

2) Is there a way to group by "A", "B", etc.? I remember doing that way
back when in dbase III+ in the late 80s. I'd get a letter "A" then a
paragraph break and then all the "A" entries. Another paragraph break would
follow (or a page break, as per the developer's choice) and the letter "B"
came after followed by the "B" entries. Etc.

Can these 2 things be done in A2K? I googled over the weekend a few times
and hunted for info in the help file but, this time, I guess I'm not asking
for the right thing as nothing pertinent came up that was of help.

Thanks. D

I'm not to clear on what you are trying to accomplish. Are you making
labels? i.e. one record per report several reports per page.
Are you making mini reports? i.e. several records per report. Several
reports per page.

You can look at sorting and grouping under the view tab in report design
view to get your alpha sort.
You can look at columns under page setup.
You can look at the force new page property in the properties of the
section.

I make labels on a 8-1/2 x 11 page that are about 3.5 in x 5 in. 4 to a
page. I purchased custom label stock from labelsonline.com. (I am not
associated with labelsonline.com)

To draw lines on your report you can use the line tool or you can put a
border around the report using the box tool.

Precise placement of the line or border will probably be difficult.

hth
Mike

"StargateFanFromWork" wrote in message
...
I need to have a 8 1/2x11" sheet of paper accommodate several, say, +/-
3in
x 4in "reports". I was given the great advice of setting a page to print
x-number of reports per page, or whatever, but this hasn't really worked
out. Difficult to know what to start with to get the target dimensions in
the finished "reports" g.

I hit upon building a custom "label" that I could use instead of the
standard page sizes and this has worked really well. But I'm stuck with 2
things - no lines as cutting guides and how to group by alphabet?

1) Re the cutting guides - is there a way to put borders around each
label
similar to what Word can do so that each "label" has a border? Yes, I
could
position everything so that I'd just cut up the sheet into 8ths or
whatever,
but it would be so much easier to have a precisely-defined, unchanging
size
via borders. I won't always have a paper cutter handy g.

2) Is there a way to group by "A", "B", etc.? I remember doing that way
back when in dbase III+ in the late 80s. I'd get a letter "A" then a
paragraph break and then all the "A" entries. Another paragraph break
would
follow (or a page break, as per the developer's choice) and the letter "B"
came after followed by the "B" entries. Etc.

Can these 2 things be done in A2K? I googled over the weekend a few times
and hunted for info in the help file but, this time, I guess I'm not
asking
for the right thing as nothing pertinent came up that was of help.

Thanks. D

On Mon, 19 Dec 2005 17:16:34 -0800, "Mike Revis"
mikeathazmatexpress.com wrote:

I'm not to clear on what you are trying to accomplish. Are you making
labels? i.e. one record per report several reports per page.
Are you making mini reports? i.e. several records per report. Several
reports per page.

I used the label option merely to help get the total size "report" I
needed - in this case, roughly 3x4" - and am looking to get several
"reports" on each standard 8 1/2 x 11" page which would hopefully be
about 6 of these reports (but in reality might turn out to just be 4
g).

The difficulty is that it's easy to put a border around each "label"
but that just puts a box around each record, not around a group of
records corresponding to the total page report size of 3x4".

I honestly don't know if this can be done, I only have a need and am
trying to figure out best process. This is an contact list db and
would like to get a small purse-sized address book as one of the
reports from it. But rather than getting one ~3x4" report only out of
each 8.5x11" paper, would like to not waste paper and get several
pages out of each sheet of standard paper.

You can look at sorting and grouping under the view tab in report design
view to get your alpha sort.

I've got the alpha sort, no problem. It's having each group separated
by a "header", or whatever it's called, and showing the corresponding
letter of the alphabet as such a grouping header.

Help doesn't help with this and the archives didn't yield anything
useful so far.

You can look at columns under page setup.

Hmmm, there may be an answer to this in there. Great.

You can look at the force new page property in the properties of the
section.

Sounds like a possibility, but will that actually force a page, I
wonder ... Might not work in this particular report I'm trying to
achieve. But will definitely take a look.

I make labels on a 8-1/2 x 11 page that are about 3.5 in x 5 in. 4 to a
page. I purchased custom label stock from labelsonline.com. (I am not
associated with labelsonline.com)

I used the label option to get the size "paper" I need, so in my case,
regular paper stock will work.

To draw lines on your report you can use the line tool or you can put a
border around the report using the box tool.

As mentioned above, drawing lines around a label just makes boxes
around each report. I need a "page border" option where A2K would
know to draw a border around 3 or 4 labels. Was wondering if there is
such a thing in A2K?

Precise placement of the line or border will probably be difficult.

Yes, which is why hoping there is a page border option g.

hth

Thank you! D

Mike

"StargateFanFromWork" wrote in message
...
I need to have a 8 1/2x11" sheet of paper accommodate several, say, +/-
3in
x 4in "reports". I was given the great advice of setting a page to print
x-number of reports per page, or whatever, but this hasn't really worked
out. Difficult to know what to start with to get the target dimensions in
the finished "reports" g.

I hit upon building a custom "label" that I could use instead of the
standard page sizes and this has worked really well. But I'm stuck with 2
things - no lines as cutting guides and how to group by alphabet?

1) Re the cutting guides - is there a way to put borders around each
label
similar to what Word can do so that each "label" has a border? Yes, I
could
position everything so that I'd just cut up the sheet into 8ths or
whatever,
but it would be so much easier to have a precisely-defined, unchanging
size
via borders. I won't always have a paper cutter handy g.

2) Is there a way to group by "A", "B", etc.? I remember doing that way
back when in dbase III+ in the late 80s. I'd get a letter "A" then a
paragraph break and then all the "A" entries. Another paragraph break
would
follow (or a page break, as per the developer's choice) and the letter "B"
came after followed by the "B" entries. Etc.

Can these 2 things be done in A2K? I googled over the weekend a few times
and hunted for info in the help file but, this time, I guess I'm not
asking
for the right thing as nothing pertinent came up that was of help.

Thanks. D

I think I see what you are trying to do.

First make a full page report.
Use page setupcolumns to make the sections (small pages) you want to be on
one full size page.
Start with 4 sections just to keep it simple.
Use sorting and grouping to make a LastName header and put a textbox with
=Left([LastName], 1) in the LastName header section. This will give you your
Letter Heading for each section.

Then use the line method in VBA to place a box around each section.

Once you get the full page looking the way you want place a subreport in the
detail section of the fullpage report with the fields for each contact.

I haven't really spent a lot of time with this but it looks like an approach
that might work.

Mike




"StargateFan" wrote in message
news
On Mon, 19 Dec 2005 17:16:34 -0800, "Mike Revis"
mikeathazmatexpress.com wrote:

I'm not to clear on what you are trying to accomplish. Are you making
labels? i.e. one record per report several reports per page.
Are you making mini reports? i.e. several records per report. Several
reports per page.

I used the label option merely to help get the total size "report" I
needed - in this case, roughly 3x4" - and am looking to get several
"reports" on each standard 8 1/2 x 11" page which would hopefully be
about 6 of these reports (but in reality might turn out to just be 4
g).

The difficulty is that it's easy to put a border around each "label"
but that just puts a box around each record, not around a group of
records corresponding to the total page report size of 3x4".

I honestly don't know if this can be done, I only have a need and am
trying to figure out best process. This is an contact list db and
would like to get a small purse-sized address book as one of the
reports from it. But rather than getting one ~3x4" report only out of
each 8.5x11" paper, would like to not waste paper and get several
pages out of each sheet of standard paper.

You can look at sorting and grouping under the view tab in report design
view to get your alpha sort.

I've got the alpha sort, no problem. It's having each group separated
by a "header", or whatever it's called, and showing the corresponding
letter of the alphabet as such a grouping header.

Help doesn't help with this and the archives didn't yield anything
useful so far.

You can look at columns under page setup.

Hmmm, there may be an answer to this in there. Great.

You can look at the force new page property in the properties of the
section.

Sounds like a possibility, but will that actually force a page, I
wonder ... Might not work in this particular report I'm trying to
achieve. But will definitely take a look.

I make labels on a 8-1/2 x 11 page that are about 3.5 in x 5 in. 4 to a
page. I purchased custom label stock from labelsonline.com. (I am not
associated with labelsonline.com)

I used the label option to get the size "paper" I need, so in my case,
regular paper stock will work.

To draw lines on your report you can use the line tool or you can put a
border around the report using the box tool.

As mentioned above, drawing lines around a label just makes boxes
around each report. I need a "page border" option where A2K would
know to draw a border around 3 or 4 labels. Was wondering if there is
such a thing in A2K?

Precise placement of the line or border will probably be difficult.

Yes, which is why hoping there is a page border option g.

hth

Thank you! D

Mike

"StargateFanFromWork" wrote in message
...
I need to have a 8 1/2x11" sheet of paper accommodate several, say, +/-
3in
x 4in "reports". I was given the great advice of setting a page to
print
x-number of reports per page, or whatever, but this hasn't really
worked
out. Difficult to know what to start with to get the target dimensions
in
the finished "reports" g.

I hit upon building a custom "label" that I could use instead of the
standard page sizes and this has worked really well. But I'm stuck
with 2
things - no lines as cutting guides and how to group by alphabet?

1) Re the cutting guides - is there a way to put borders around each
label
similar to what Word can do so that each "label" has a border? Yes, I
could
position everything so that I'd just cut up the sheet into 8ths or
whatever,
but it would be so much easier to have a precisely-defined, unchanging
size
via borders. I won't always have a paper cutter handy g.

2) Is there a way to group by "A", "B", etc.? I remember doing that
way
back when in dbase III+ in the late 80s. I'd get a letter "A" then a
paragraph break and then all the "A" entries. Another paragraph break
would
follow (or a page break, as per the developer's choice) and the letter
"B"
came after followed by the "B" entries. Etc.

Can these 2 things be done in A2K? I googled over the weekend a few
times
and hunted for info in the help file but, this time, I guess I'm not
asking
for the right thing as nothing pertinent came up that was of help.

Thanks. D

"Mike Revis" mikeathazmatexpress.com wrote in message
...
I think I see what you are trying to do.

First make a full page report.
Use page setupcolumns to make the sections (small pages) you want to be
on
one full size page.
Start with 4 sections just to keep it simple.
Use sorting and grouping to make a LastName header and put a textbox with
=Left([LastName], 1) in the LastName header section. This will give you
your
Letter Heading for each section.

Then use the line method in VBA to place a box around each section.

Once you get the full page looking the way you want place a subreport in
the
detail section of the fullpage report with the fields for each contact.

I haven't really spent a lot of time with this but it looks like an
approach
that might work.

This sounds like something that will do exactly what's needed. This is
great. I'll start working on this, thanks.

The good thing is that once this is done, this db will be good for life g.
I'll be able to print out a large address book to put beside the phone at
home, but I'll also hopefully be able to print a smaller version - what I'm
trying to do here - that will allow me to get rid of those small
carry-around address/phone books.

I know, electronic organizers with PIMs and Palms, etc., etc., are here -
but after battling with batteries running out of juice in a lot less time
than expected and then faulty batteries - both incidences which meant losing
data twice in 3 years - I've given up on them g. The paper one will
always be handy.

Thank you! D

Mike




"StargateFan" wrote in message
news
On Mon, 19 Dec 2005 17:16:34 -0800, "Mike Revis"
mikeathazmatexpress.com wrote:

I'm not to clear on what you are trying to accomplish. Are you making
labels? i.e. one record per report several reports per page.
Are you making mini reports? i.e. several records per report. Several
reports per page.

I used the label option merely to help get the total size "report" I
needed - in this case, roughly 3x4" - and am looking to get several
"reports" on each standard 8 1/2 x 11" page which would hopefully be
about 6 of these reports (but in reality might turn out to just be 4
g).

The difficulty is that it's easy to put a border around each "label"
but that just puts a box around each record, not around a group of
records corresponding to the total page report size of 3x4".

I honestly don't know if this can be done, I only have a need and am
trying to figure out best process. This is an contact list db and
would like to get a small purse-sized address book as one of the
reports from it. But rather than getting one ~3x4" report only out of
each 8.5x11" paper, would like to not waste paper and get several
pages out of each sheet of standard paper.

You can look at sorting and grouping under the view tab in report
design
view to get your alpha sort.

I've got the alpha sort, no problem. It's having each group separated
by a "header", or whatever it's called, and showing the corresponding
letter of the alphabet as such a grouping header.

Help doesn't help with this and the archives didn't yield anything
useful so far.

You can look at columns under page setup.

Hmmm, there may be an answer to this in there. Great.

You can look at the force new page property in the properties of the
section.

Sounds like a possibility, but will that actually force a page, I
wonder ... Might not work in this particular report I'm trying to
achieve. But will definitely take a look.

I make labels on a 8-1/2 x 11 page that are about 3.5 in x 5 in. 4 to a
page. I purchased custom label stock from labelsonline.com. (I am not
associated with labelsonline.com)

I used the label option to get the size "paper" I need, so in my case,
regular paper stock will work.

To draw lines on your report you can use the line tool or you can put a
border around the report using the box tool.

As mentioned above, drawing lines around a label just makes boxes
around each report. I need a "page border" option where A2K would
know to draw a border around 3 or 4 labels. Was wondering if there is
such a thing in A2K?

Precise placement of the line or border will probably be difficult.

Yes, which is why hoping there is a page border option g.

hth

Thank you! D

Mike

"StargateFanFromWork" wrote in message
...
I need to have a 8 1/2x11" sheet of paper accommodate several, say,
+/-
3in
x 4in "reports". I was given the great advice of setting a page to
print
x-number of reports per page, or whatever, but this hasn't really
worked
out. Difficult to know what to start with to get the target
dimensions
in
the finished "reports" g.

I hit upon building a custom "label" that I could use instead of the
standard page sizes and this has worked really well. But I'm stuck
with 2
things - no lines as cutting guides and how to group by alphabet?

1) Re the cutting guides - is there a way to put borders around each
label
similar to what Word can do so that each "label" has a border? Yes,
I
could
position everything so that I'd just cut up the sheet into 8ths or
whatever,
but it would be so much easier to have a precisely-defined,
unchanging
size
via borders. I won't always have a paper cutter handy g.

2) Is there a way to group by "A", "B", etc.? I remember doing that
way
back when in dbase III+ in the late 80s. I'd get a letter "A" then a
paragraph break and then all the "A" entries. Another paragraph
break
would
follow (or a page break, as per the developer's choice) and the
letter
"B"
came after followed by the "B" entries. Etc.

Can these 2 things be done in A2K? I googled over the weekend a few
times
and hunted for info in the help file but, this time, I guess I'm not
asking
for the right thing as nothing pertinent came up that was of help.

Thanks. D

On Wed, 21 Dec 2005 07:34:10 -0800, "Mike Revis"
mikeathazmatexpress.com wrote:

I think I see what you are trying to do.

First make a full page report.
Use page setupcolumns to make the sections (small pages) you want to be on
one full size page.
Start with 4 sections just to keep it simple.
Use sorting and grouping to make a LastName header and put a textbox with
=Left([LastName], 1) in the LastName header section. This will give you your
Letter Heading for each section.

Mike, hi!

I put this into my db the other day and entered some data. It worked
at the time because by coincidence, the first word that the letter was
taken from happened to be the same in the test run. Now that I've
input multiple entries, I've found something that isn't so good. This
will give a header for each new word, which as you can imagine, isn't
what is needed. Under what should be one "B" header, for example, I
currently have 14 "B" headers. Is there a way around this. In the
late 80s was able to group very easily in old DOS-based dBase III+ so
there's got to be a way to do this in A2K! g

Do you have any ideas? Thanks much! D





p.s., the small reports are sort of working out. [I miss my FMP for
this report g which is so easy to set custom page sizes with fixed
columns, etc., with lines around _groups_ of records. And the
settings _stay_.] I opened the report again this morning and had to
reset the page margins and columns _again_ (this is the third time).
Hopefully they stay put now g. I didn't do anything different so
don't know what happened as yet. It worked and then it didn't work.
But at least, though I'm not getting what I really needed, I'll be
able to live with what I get, which is the important thing. Nothing
re line drawing worked so will just have to position everything
carefully and cut pages up uniformly. Not the ideal, but as long as I
can get a working copy, that's all that matters in the end. g

Then use the line method in VBA to place a box around each section.

Once you get the full page looking the way you want place a subreport in the
detail section of the fullpage report with the fields for each contact.

I haven't really spent a lot of time with this but it looks like an approach
that might work.

Mike




"StargateFan" wrote in message
news
On Mon, 19 Dec 2005 17:16:34 -0800, "Mike Revis"
mikeathazmatexpress.com wrote:

I'm not to clear on what you are trying to accomplish. Are you making
labels? i.e. one record per report several reports per page.
Are you making mini reports? i.e. several records per report. Several
reports per page.

I used the label option merely to help get the total size "report" I
needed - in this case, roughly 3x4" - and am looking to get several
"reports" on each standard 8 1/2 x 11" page which would hopefully be
about 6 of these reports (but in reality might turn out to just be 4
g).

The difficulty is that it's easy to put a border around each "label"
but that just puts a box around each record, not around a group of
records corresponding to the total page report size of 3x4".

I honestly don't know if this can be done, I only have a need and am
trying to figure out best process. This is an contact list db and
would like to get a small purse-sized address book as one of the
reports from it. But rather than getting one ~3x4" report only out of
each 8.5x11" paper, would like to not waste paper and get several
pages out of each sheet of standard paper.

You can look at sorting and grouping under the view tab in report design
view to get your alpha sort.

I've got the alpha sort, no problem. It's having each group separated
by a "header", or whatever it's called, and showing the corresponding
letter of the alphabet as such a grouping header.

Help doesn't help with this and the archives didn't yield anything
useful so far.

You can look at columns under page setup.

Hmmm, there may be an answer to this in there. Great.

You can look at the force new page property in the properties of the
section.

Sounds like a possibility, but will that actually force a page, I
wonder ... Might not work in this particular report I'm trying to
achieve. But will definitely take a look.

I make labels on a 8-1/2 x 11 page that are about 3.5 in x 5 in. 4 to a
page. I purchased custom label stock from labelsonline.com. (I am not
associated with labelsonline.com)

I used the label option to get the size "paper" I need, so in my case,
regular paper stock will work.

To draw lines on your report you can use the line tool or you can put a
border around the report using the box tool.

As mentioned above, drawing lines around a label just makes boxes
around each report. I need a "page border" option where A2K would
know to draw a border around 3 or 4 labels. Was wondering if there is
such a thing in A2K?

Precise placement of the line or border will probably be difficult.

Yes, which is why hoping there is a page border option g.

hth

Thank you! D

Mike

"StargateFanFromWork" wrote in message
...
I need to have a 8 1/2x11" sheet of paper accommodate several, say, +/-
3in
x 4in "reports". I was given the great advice of setting a page to
print
x-number of reports per page, or whatever, but this hasn't really
worked
out. Difficult to know what to start with to get the target dimensions
in
the finished "reports" g.

I hit upon building a custom "label" that I could use instead of the
standard page sizes and this has worked really well. But I'm stuck
with 2
things - no lines as cutting guides and how to group by alphabet?

1) Re the cutting guides - is there a way to put borders around each
label
similar to what Word can do so that each "label" has a border? Yes, I
could
position everything so that I'd just cut up the sheet into 8ths or
whatever,
but it would be so much easier to have a precisely-defined, unchanging
size
via borders. I won't always have a paper cutter handy g.

2) Is there a way to group by "A", "B", etc.? I remember doing that
way
back when in dbase III+ in the late 80s. I'd get a letter "A" then a
paragraph break and then all the "A" entries. Another paragraph break
would
follow (or a page break, as per the developer's choice) and the letter
"B"
came after followed by the "B" entries. Etc.

Can these 2 things be done in A2K? I googled over the weekend a few
times
and hunted for info in the help file but, this time, I guess I'm not
asking
for the right thing as nothing pertinent came up that was of help.

Thanks. D

On Mon, 02 Jan 2006 09:55:29 -0500, StargateFan
wrote:

On Wed, 21 Dec 2005 07:34:10 -0800, "Mike Revis"
mikeathazmatexpress.com wrote:

I think I see what you are trying to do.

[snip]

Use sorting and grouping to make a LastName header and put a textbox with
=Left([LastName], 1) in the LastName header section. This will give you your
Letter Heading for each section.

[snip]

I hope it's okay but starting a new thread. I thought this whole
grouping and header thing was working, but it's not. When I used it
during the initial few records I input, the records started with a
different letter of the alphabet so the header thing seemed to work.
To my dismay today upon entering many more records, I have at last
count for example, 25 records showing up under 14 "B" headers with
each grouping underneath containing 1 to 4 entries. That's because I
just happened to enter info about bus routes so first field is the
same in many, with additional bus station info/bus direction and bus
stop phone code being what changed which shows up in 2 other fields.
Otherwise, with a slightly different format, each of those 25 records
would have a header all its own making for 25 "B" headers!!!! g
Needless to say, this is _not_ good.

Is there a way to get a printout that groups _all_ entries starting
with same letter? So that all A entries fall under a group header of
"A", same for B, C and so forth down the alphabet? As I mentioned in
the original thread, this was so very easy to do in old DOS days over
15 years ago in dBase III+ so know that the much more powerful A2K
should have a way to do this, too. The archives have revealed only
issues regarding grouping, unfortunately with nothing coming up for
this type of thing and reporting.

Thank you! D

On Mon, 02 Jan 2006 09:55:29 -0500, StargateFan
wrote:

On Wed, 21 Dec 2005 07:34:10 -0800, "Mike Revis"
mikeathazmatexpress.com wrote:

I think I see what you are trying to do.

First make a full page report.
Use page setupcolumns to make the sections (small pages) you want to be on
one full size page.
Start with 4 sections just to keep it simple.
Use sorting and grouping to make a LastName header and put a textbox with
=Left([LastName], 1) in the LastName header section. This will give you your
Letter Heading for each section.

Mike, hi!

I put this into my db the other day and entered some data. It worked
at the time because by coincidence, the first word that the letter was
taken from happened to be the same in the test run. Now that I've
input multiple entries, I've found something that isn't so good. This
will give a header for each new word, which as you can imagine, isn't
what is needed. Under what should be one "B" header, for example, I
currently have 14 "B" headers. Is there a way around this. In the
late 80s was able to group very easily in old DOS-based dBase III+ so
there's got to be a way to do this in A2K! g

Do you have any ideas? Thanks much! D

[snip]

Started a new thread as I believe that's what I should have done?

Thanks.

You should be grouping on the expression your were given and not on the field.

ALthough you can group on the field.

In the sorting and grouping dialog,
Group on: Prefix Characters
Group Interval: 1

That will group on the first character of the group.

For detailed help, open the Sorting and Grouping dialog, and put the cursor in
the Group On choice list, and press the F1 key.

StargateFan wrote:

On Mon, 02 Jan 2006 09:55:29 -0500, StargateFan
wrote:

On Wed, 21 Dec 2005 07:34:10 -0800, "Mike Revis"
mikeathazmatexpress.com wrote:

I think I see what you are trying to do.

[snip]

Use sorting and grouping to make a LastName header and put a textbox with
=Left([LastName], 1) in the LastName header section. This will give you your
Letter Heading for each section.

[snip]

I hope it's okay but starting a new thread. I thought this whole
grouping and header thing was working, but it's not. When I used it
during the initial few records I input, the records started with a
different letter of the alphabet so the header thing seemed to work.
To my dismay today upon entering many more records, I have at last
count for example, 25 records showing up under 14 "B" headers with
each grouping underneath containing 1 to 4 entries. That's because I
just happened to enter info about bus routes so first field is the
same in many, with additional bus station info/bus direction and bus
stop phone code being what changed which shows up in 2 other fields.
Otherwise, with a slightly different format, each of those 25 records
would have a header all its own making for 25 "B" headers!!!! g
Needless to say, this is _not_ good.

Is there a way to get a printout that groups _all_ entries starting
with same letter? So that all A entries fall under a group header of
"A", same for B, C and so forth down the alphabet? As I mentioned in
the original thread, this was so very easy to do in old DOS days over
15 years ago in dBase III+ so know that the much more powerful A2K
should have a way to do this, too. The archives have revealed only
issues regarding grouping, unfortunately with nothing coming up for
this type of thing and reporting.

Thank you! D

Got it! Wow, I was just not getting it. I was going around in
circles so then decided to re-build the report from scratch. That's
where I finally found the sorting and grouping done by the first
letter. There are so many options in the report wizard it's tough for
a newbie to know what to pick, but I was forewarned this time on what
to look for g. I see that the elements are identical in both
reports it's just that in my earlier one, somewhere I must be missing
something vital. As I work through fine-tuning this report down to
size, I might figure out where I went wrong before.

Thanks. Your post helped me to find the answer by working through
everything. Appreciate it. D

***********************************************
On Mon, 02 Jan 2006 15:26:21 -0500, John Spencer
wrote:

You should be grouping on the expression your were given and not on the field.

ALthough you can group on the field.

In the sorting and grouping dialog,
Group on: Prefix Characters
Group Interval: 1

That will group on the first character of the group.

For detailed help, open the Sorting and Grouping dialog, and put the cursor in
the Group On choice list, and press the F1 key.

StargateFan wrote:

On Mon, 02 Jan 2006 09:55:29 -0500, StargateFan
wrote:

On Wed, 21 Dec 2005 07:34:10 -0800, "Mike Revis"
mikeathazmatexpress.com wrote:

I think I see what you are trying to do.

[snip]

Use sorting and grouping to make a LastName header and put a textbox with
=Left([LastName], 1) in the LastName header section. This will give you your
Letter Heading for each section.

[snip]

I hope it's okay but starting a new thread. I thought this whole
grouping and header thing was working, but it's not. When I used it
during the initial few records I input, the records started with a
different letter of the alphabet so the header thing seemed to work.
To my dismay today upon entering many more records, I have at last
count for example, 25 records showing up under 14 "B" headers with
each grouping underneath containing 1 to 4 entries. That's because I
just happened to enter info about bus routes so first field is the
same in many, with additional bus station info/bus direction and bus
stop phone code being what changed which shows up in 2 other fields.
Otherwise, with a slightly different format, each of those 25 records
would have a header all its own making for 25 "B" headers!!!! g
Needless to say, this is _not_ good.

Is there a way to get a printout that groups _all_ entries starting
with same letter? So that all A entries fall under a group header of
"A", same for B, C and so forth down the alphabet? As I mentioned in
the original thread, this was so very easy to do in old DOS days over
15 years ago in dBase III+ so know that the much more powerful A2K
should have a way to do this, too. The archives have revealed only
issues regarding grouping, unfortunately with nothing coming up for
this type of thing and reporting.

Thank you! D