G
Guest
My database stores information about internal controls of an organization.
Each control has certain attributes known as assertions that is relates to.
There are 5 assertions, but for this example, we will only use 2,
Existence/Occurrence & Valuation. On the data entry form where the user
enters the data concerning the controls, all assertions are displayed with a
checkbox. The resulting data is stored in the database as Yes or No. A
control may have multiple assertions.
I have a report that summarizes the controls and lists the assertions for
each control. Instead of displaying each assertion with a Yes/No, I want
them to appear with abbreviations. For example, if the control only relates
to Valuation, I want it to appear with a “V†or if it relates to both
Existence/Occurrence and Valuation, I want it to appear with a “EOâ€,â€Vâ€.
Currently, I have a text box on my form that says If assertion1=Yes,EO,†“
and another text box that says If assertion2=Yes,V,†“. These boxes are
hidden. Then I have a text box that adds up all of these hidden boxes. The
result is that I get my abbreviation in a string like “EO,V,,,†but I end up
with a few blank spaces and commas for the other assertions that may not have
been present. This way works and I don’t really care about the blank spaces
and extra commas, but it just seems cumbersome and I wanted to know if there
was an easier way to accomplish this task. Thanks.
Each control has certain attributes known as assertions that is relates to.
There are 5 assertions, but for this example, we will only use 2,
Existence/Occurrence & Valuation. On the data entry form where the user
enters the data concerning the controls, all assertions are displayed with a
checkbox. The resulting data is stored in the database as Yes or No. A
control may have multiple assertions.
I have a report that summarizes the controls and lists the assertions for
each control. Instead of displaying each assertion with a Yes/No, I want
them to appear with abbreviations. For example, if the control only relates
to Valuation, I want it to appear with a “V†or if it relates to both
Existence/Occurrence and Valuation, I want it to appear with a “EOâ€,â€Vâ€.
Currently, I have a text box on my form that says If assertion1=Yes,EO,†“
and another text box that says If assertion2=Yes,V,†“. These boxes are
hidden. Then I have a text box that adds up all of these hidden boxes. The
result is that I get my abbreviation in a string like “EO,V,,,†but I end up
with a few blank spaces and commas for the other assertions that may not have
been present. This way works and I don’t really care about the blank spaces
and extra commas, but it just seems cumbersome and I wanted to know if there
was an easier way to accomplish this task. Thanks.