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]

Re: Report Section Header Question

On Jun 26, 6:46 pm, brianlas <br...@laselva. comwrote:

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]

Re: Report Section Header Question

On Jun 26, 5:54 pm, Roger <lesperan...@na tpro.comwrote:

On Jun 26, 6:46 pm, brianlas <br...@laselva. comwrote:
>

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
BusinessStateor Province,
which is precisely the field that I specify in the Sorting and
Grouping dialog. Then,
in the header, I just have the BusinessStateOr Province 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]

Re: Report Section Header Question

On Jun 26, 7:23 pm, brianlas <br...@laselva. comwrote:

On Jun 26, 5:54 pm, Roger <lesperan...@na tpro.comwrote:
>
>
>
>
>

On Jun 26, 6:46 pm, brianlas <br...@laselva. comwrote:

>

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
BusinessStateor Province,
which is precisely the field that I specify in the Sorting and
Grouping dialog. Then,
in the header, I just have the BusinessStateOr Province 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 -

businessStateor Province 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]

Re: Report Section Header Question

On Jun 26, 7:35 pm, Roger <lesperan...@na tpro.comwrote:

On Jun 26, 7:23 pm, brianlas <br...@laselva. comwrote:
>
>
>
>
>

On Jun 26, 5:54 pm, Roger <lesperan...@na tpro.comwrote:

>

On Jun 26, 6:46 pm, brianlas <br...@laselva. comwrote:

>

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
BusinessStateor Province,
which is precisely the field that I specify in the Sorting and
Grouping dialog. Then,
in the header, I just have the BusinessStateOr Province 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 -

>
businessStateor Province 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