Append query skipping row????

[LiverEatnJohnson]

Ok I made an append query that looks like this



INSERT INTO Classes ( site, type, s_date, coach1, coach2, coach3 )
SELECT DISTINCT Both.Site, Both.Type, Both.Date, Both.RiderCoach1, Both.RiderCoach2, Both.RiderCoach3
FROM [Both];

but when I run it, it skips filling the coach1 row but fills all other rows anyone got an idea why it might do that?? Thanks in advance.

P.S.
As a note if I run

SELECT DISTINCT Both.Site, Both.Type, Both.Date, Both.RiderCoach1, Both.RiderCoach2, Both.RiderCoach3
FROM [Both];

just to see if it gets the RiderCoach1 row so it can put it in the coach 1 row. It does get the names.

[June7]

Need to examine database. If you want to provide, follow instructions at bottom of my post.

[LiverEatnJohnson]

Need to examine database. If you want to provide, follow instructions at bottom of my post.

I got this one. All I had to do was delete the table, recreate it and run the querry again and then it worked. But I don't know how to mark this as solved.