aplona
asked on
Access 2003 expression for Trim
Hello,
I am a newbie to access and am having some difficulty with the following:
I have a control source in an access report that places city org and name in the correct order I need them to show up. It looks loke this: =Trim([City] & " -- " & [Organization] & "--" & [Full Name])
This works fine except I need this, if the name listed does not have an organization I need only "" not "--" if they do have an organization they will need the "--"
I am a newbie to access and am having some difficulty with the following:
I have a control source in an access report that places city org and name in the correct order I need them to show up. It looks loke this: =Trim([City] & " -- " & [Organization] & "--" & [Full Name])
This works fine except I need this, if the name listed does not have an organization I need only "" not "--" if they do have an organization they will need the "--"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>I have about 30 reports though, how do I add that to all of them at the same time?
Unless all 30 report's RecordSource's are the same, you don't add them 'at the same time', you find each RecordSource / ControlSource and do it one at a time.
Unless all 30 report's RecordSource's are the same, you don't add them 'at the same time', you find each RecordSource / ControlSource and do it one at a time.
ASKER
I have this under the control source in the report. All reports I have will have the same control source. Is it possible to change all of the report control source to this all at once rather than doing into each one.
>I have this under the control source in the report.
Just to clarify terms, reports have a record source, and all data-bound controls on a report have a control source.
Just to clarify terms, reports have a record source, and all data-bound controls on a report have a control source.
ASKER
I see. The record source for each report I have is the query. It looks like I will have to do this individually right?
>It looks like I will have to do this individually right?
You'll have to flush out all the unique queries that serve as the record sources for your 30-ish reports, and change each one.
You'll have to flush out all the unique queries that serve as the record sources for your 30-ish reports, and change each one.
ASKER