Help with Report

[Steven Stewart]

Hi there,

I have a text box on a report that displays a "Team" name. Although, in
the database, it is important for the team to be stored with three
different titles (S&F West, S&F East, S&F Atlantic), on the actual
report I want it to just say "S&F" for all three.

Any idea how I could accomplish this seemingly simple task?

Thanks!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Lyle Fairfield]

Steven Stewart <o6***@unb.ca> wrote in news:3fb4cfab$0$198$75868355
@news.frii.net:

Hi there,

I have a text box on a report that displays a "Team" name. Although, in
the database, it is important for the team to be stored with three
different titles (S&F West, S&F East, S&F Atlantic), on the actual
report I want it to just say "S&F" for all three.

Any idea how I could accomplish this seemingly simple task?

Thanks!

If it's always "S&F" then use a label the caption of which is
"S&F".

If it's always the first three characters then use a calculated field in
the underlying query or a calculated control on the report:
= Left(Title, 3)

If it's always the characters up to but not including the first space then
use a calculated field in the underlying query or a calculated control on
the report:
=Left(Title, InStr(Title, " " ))

all expressions are air code.
--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)

[Steven Stewart]

Thanks Lyle...it worked. I knew it'd be something simple!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!