On opening of report - if, then type question (1 Viewer)

[WebFaktor]

Hi - I have a unique record identifier within the records I report known as "MaterialNumber"

MaterialNumbers can be of two distinct types, for example:
M0001.01 (8 digits in length total)
M0001.01.01 (11 digits in length total)

The question I would like to ask of the query from which the report is based and have it perhaps performed when the report opens is: "If the MaterialNumber is 8 digits in length, then look and see if any 11 digits in length MaterialNumbers exist that are identical to the 8 digit material number with their first 8 digits, and then to report these 11 digit Material Numbers as well as the 8 digit Material Number from which they are derived"

Any help you would care to share is very much appreciated!

Regards,

WF

 

[WebFaktor]

Further explaination. . .

It would be only when the report references an 8 digit MaterialNumber that I would like this functionality activated. When the report references an 11 digit material number I would NOT want the 'above defined' functionality to occur.

Here’s some FYIs (sorry I didn't post these with first message.):

· An 8 digit MaterialNumber identifies a document.
· An 11 digit MaterialNumber identifies a portion of a document.
· A document may or may not be divided into sections that are identified by 11 digit MaterialNumbers:
If so, the Document would be summarized/identified as follows, for example:
M0001.01 = Main Document Number
M0001.01.01 = Section 1 of main document M0001.01
M0001.01.02 = Section 2 of main document M0001.01
M0001.01.03 = Section 3 of main document M0001.01
Etc. . .
If Not, the Document would be summarized/identified as follows, for example:
M0001.01 = Entire Document Number with no sections

Thus - a person may only want to see a report on (per above example) M0001.01.03. If this were the case, they would not want to see M0001.01.01 & M0001.01.02.

On the other hand, if a person wants to see M0001.01, I want to make sure the report calls up M0001.01, M0001.01.01, M0001.01.02, and M0001.01.03.