Report Criteria

[Guest]

I have a report based on a Parameter Query that asks the user to enter Org
Number. Some Orgs have sub org numbers (i.e., Org 0001 may have a suborg of
0001-1. How can I get the report to include not only Org 0001 but also
include any suborgs?

 

[tina]

assuming that the "sub-org" value is stored in the same field as the "org"
value, change the query criteria to

Like [Enter the Org Number] & "*"

hth

 

[parry]

hi