I have a query which displays information from several different audit sources, however in the form for a particular dept is it possible to hide results from other departments? I want to avoid having several queries for the same information just diff depts.
ie if [AuditSource] = "InternalQC" don't show or something to that effect?!
Thank you guys!