Report Section Header Question

[brianlas]

Hi,

I have a contacts report that groups and displays records according to
a 2-character state abbreviation, which is stored in the database. My
report displays the 2-character state abbreviation in the section
header, just as I want. However, now I want to print instead the full
name of the state in the report header instead of the abbreviation.
What is the best approach for doing this?

Thanks,

Brian

[Roger]

On Jun 26, 6:46*pm, brianlas <[e-mail]:

Hi,

I have a contacts report that groups and displays records according to
a 2-character state abbreviation, which is stored in the database. My
report displays the 2-character state abbreviation in the section
header, just as I want. However, now I want to print instead the full
name of the state in the report header instead of the abbreviation.
What is the best approach for doing this?

Thanks,

Brian

change your query to include a join to your 'state' table
and use the state name on your report

[brianlas]

On Jun 26, 5:54*pm, Roger <[e-mail]:

On Jun 26, 6:46*pm, brianlas <[e-mail]:

Hi,

I have a contacts report that groups and displays records according to
a 2-character state abbreviation, which is stored in the database. My
report displays the 2-character state abbreviation in the section
header, just as I want. However, now I want to print instead the full
name of the state in the report header instead of the abbreviation.
What is the best approach for doing this?

Thanks,

Brian

change your query to include a join to your 'state' table
and use the state name on your report

I'm confused about this. The control source is called
BusinessStateorProvince,
which is precisely the field that I specify in the Sorting and
Grouping dialog. Then,
in the header, I just have the BusinessStateOrProvince field in the
header. I don't
know where to put a query or how to change what's in the header. I've
done quite
a bit of VBA programming, but I seem to have a giant mental block
about this one.
Could you please elaborate (and don't assume I know very much,
apparently! ;-)

Thanks again,

Brian

[Roger]

On Jun 26, 7:23*pm, brianlas <[e-mail]:

On Jun 26, 5:54*pm, Roger <[e-mail]:

On Jun 26, 6:46*pm, brianlas <[e-mail]:

Hi,

I have a contacts report that groups and displays records according to
a 2-character state abbreviation, which is stored in the database. My
report displays the 2-character state abbreviation in the section
header, just as I want. However, now I want to print instead the full
name of the state in the report header instead of the abbreviation.
What is the best approach for doing this?

Thanks,

Brian

change your query to include a join to your 'state' table
and use the state name on your report

I'm confused about this. The control source is called
BusinessStateorProvince,
which is precisely the field that I specify in the Sorting and
Grouping dialog. Then,
in the header, I just have the BusinessStateOrProvince field in the
header. I don't
know where to put a query or how to change what's in the header. I've
done quite
a bit of VBA programming, but I seem to have a giant mental block
about this one.
Could you please elaborate (and don't assume I know very much,
apparently! ;-)

Thanks again,

Brian- Hide quoted text -

- Show quoted text -

businessStateorProvince is a field found in the report's recordsource
is it a field in a table or a query
if the recordsource is a query, join in the table that converts
abbreviations to names
if it's a table, create a new query using this table and the
stateOrProvince table, and use that query as the report's recordsource

[brianlas]

On Jun 26, 7:35*pm, Roger <[e-mail]:

On Jun 26, 7:23*pm, brianlas <[e-mail]:

On Jun 26, 5:54*pm, Roger <[e-mail]:

On Jun 26, 6:46*pm, brianlas <[e-mail]:

Hi,

I have a contacts report that groups and displays records accordingto
a 2-character state abbreviation, which is stored in the database. My
report displays the 2-character state abbreviation in the section
header, just as I want. However, now I want to print instead the full
name of the state in the report header instead of the abbreviation.
What is the best approach for doing this?

Thanks,

Brian

change your query to include a join to your 'state' table
and use the state name on your report

I'm confused about this. The control source is called
BusinessStateorProvince,
which is precisely the field that I specify in the Sorting and
Grouping dialog. Then,
in the header, I just have the BusinessStateOrProvince field in the
header. I don't
know where to put a query or how to change what's in the header. I've
done quite
a bit of VBA programming, but I seem to have a giant mental block
about this one.
Could you please elaborate (and don't assume I know very much,
apparently! ;-)

Thanks again,

Brian- Hide quoted text -

- Show quoted text -

businessStateorProvince is a field found in the report's recordsource
is it a field in a table or a query
if the recordsource is a query, join in the table that converts
abbreviations to names
if it's a table, create a new query using this table and the
stateOrProvince table, and use that query as the report's recordsource- Hide quoted text -

- Show quoted text -

Roger, you saved my life! Thanks so much for your patience and clear
explanation. I'm a little embarrassed how easy it was to do, NOW THAT
I KNOW HOW TO DO IT (thanks to you). It's sometimes hard for me to get
my head around some of this, for some reason. ;-( Hope you lurk here
often, because if/when I get really stuck again, I'll turn here
first!

Again, thanks so much!!!

Brian