Anyway to show Parameter in "matched" side of Unmatched Query?

[Hillary]

I am working in our main ERP Database. The permissions in this database default to yes but can be changed to no or read. The table USER_PGM_AUTHORITY only stores no and read permissions.

I have two queries, qryPrograms and Components and qryPrograms and Components by User. The first query has all the Programs and Components the second query has all the no and read permissions for a user. An Unmatched Query between the two returns the yes permissions for a user.

I want to be able to return User_ID which is the parameter for qryPrograms and Components by User but the the nature of the Unmatched Query won't return any records where User_ID exists.

Is there any way to bring a parameter value from the "matched" side of an Unmatched Query?

Thanks,

Hillary

 

[PHV]

JonFer, have you read my post of July 1st ?

 

[JonFer]

PHV - Yes. Hillary hadn't indicated that she had read my post where I further explained your suggestion as well as provided another option to get her desired results.