Query to show whether certain types of things are assigned to a person

The underlying problem is an inappropriate table design.

The user of aliases for the real field names helps expose this problem:

Whenever you see this pattern of "Something" + a counter, that's a sign the original data was either in Excel or a table created without considering good relational table design.

So, the solution is to Normalize this table properly so that the query becomes simple and direct.

Actually, you need three tables here:

Employees

Items

EmployeeItemAssignments

Employees needs its Primary Key, such as EmployeeID.

Items needs its Primary Key, such as ItemID.

In the third table, you have one record for each employee and Item combination.

If an employee is assigned one item, there will be only one record for that employee-item assignment.

If an employee is assigned two items, there will be two records for that employee with the two item assignments.

These assignments are designated by including the appropriate EmployeeID and the appropriate ItemID for each assignment.

Additional fields could include the date the assignment was made and the date it ended, if that's relevant to your business model.

That's a narrative explanation. For a deeper background, I suggest investing time in researching Database Normalization. Look for Many-to-Many relationships and how they are handled properly.

I expect you'll receive additional, more technically detailed responses, as well.

The key point is that improper, or non-normalized tables make for rough sledding when you need to query them.

I just want to clarify to make sure my information got across before changing how my database is built.

The ItemTypeA stuff was just an example of what I was hoping to see from the query. Below is a mockup of the table data itself.

It's not just whether an employee is assigned an item, it's whether they are assigned a particular type of item. For these purposes if they've been assigned one, two, or ten doesn't matter. Hence why I was just trying for a True/False field with the name of the item (ItemTypeA as a substitute for the actual type name) as the column name.

To return a result table as you've described a crosstab query would be used.  For an example take a look at DatabaseBasics.zip in my Dropbox public databases folder at:

https://www.dropbox.com/scl/fo/0scigd3r48hx5xrev2jrf/AB0-GMdTgMAO5O1cGdr3QW0?rlkey=ib6bs6g9jqcrywwzivur3265t&dl=0

In this little demo file the following section illustrates a crosstab query. 

18. Returning rows with data as column headings by means of a crosstab query

If amended as follows, rather than returning the total amounts at the intersections of the column and row headings, the query would return TRUE, expressed as -1, in place of the currency values returned in the demo:

TRANSFORM IIF(COUNT(*)>0,TRUE,FALSE)

SELECT FirstName, LastName, SUM(TransactionAmount) AS TotalAmount

FROM Customers RIGHT JOIN (Calendar LEFT JOIN Transactions

ON Calendar.calDate = Transactions.TransactionDate)

ON Customers.CustomerID = Transactions.CustomerID

WHERE YEAR(calDate) = 2009 AND MONTH(calDate) = 4

GROUP BY FirstName, LastName

PIVOT calDate;

Because of the OUTER JOINs the above would  return a specious row with zero length strings at the  FirstName and LastName column positions.  This can be removed by a further query as in the demo.

Ah, I see. You showed the "after" not the "before". Sorry.

A crosstab will work, as Ken detailed for you.

Thank you very much for the help. And thank you George as well, and I apologize for not being clearer in my initial post.