Is it possible to get in my example the name "Pietje" and on which workday it is registrered in the table.

The screen of the table

I'm search for this so i can make a textbox with the text : "OMD: Pietje on thursday" or something in this same sense.

You should only have name once.

Use an ID number for each name then use that ID in each table.

Then you can search anywhere on person ID.

in your example the name appears twice in that column. Would you always only want the most current date in the other column ?

i have to make a roster of a week and i will be visible when there is an free day. Pietje will be twice in a column.

The roster is generated with vba with names and it saves in this table. For every day the roster is generated.

The trick is to get the name en workday for the omd from this table

unless i am missing something, sounds like a simple query. have you tried it in the query design?