Recent content by AccessVBAUser

(Case WHEN [ItemType] IN ('SPRL' , 'SPRS') AND [CompItemType] IN ('BINS' , 'LINS' , 'INS') THEN 'SF-Insert' WHEN [ItemType] IN ('SPRL' , 'SPRS') AND [CompItemType] IN ('ESBNK', 'ESPRT' , 'ENDSH') THEN 'SF-EndSheet' WHEN [ItemType] IN ('SPRL' , 'SPRS') AND [CompItemType] IN ('BCOV' , 'CSDE'...

Yes, that is exactly what i was looking for. I don't know why i didn't think of that. Thank you so much for your help and timely response.

Hello, I have been given a list of names in excel. I have imported those names into a table in access named Employee. So the table, column and names look like: Table: Employee Column: Employee Row1 Todd Row2 Mike Row3 Sarah I need to take this table and turn it into a table (like a matrix in...