I edited the query as you mentioned and it worked.

Now I have additional requirements to be added:

REQ #1: I need to associate usernames instead of UserID

So how would I go about translating the UserID to match the Username?

REQ #2: I need to include a total for QtyRxFilled and QtyRxChecked

Below is how the tables are structured in the database

Users.UserID varchar(10) NOT NULL

RxProductivity.WhoVerified varchar (10) NULL

RxProductivity.Whochecked varchar (10) NULL

Again, I thank you for your assistance with this.

Your help is greatly appreciated.