Issue with joining 2-tbls

[djclntn]

I have a Tbl which does not contain a Date fld, but contain the days of the week,


eg. “Sun” “Mon” ” Tue” etc.

I need for the days of the week to run for Sat to Sun, via in the tbl or in a qry, but without having a date field I cannot format my weekdays to “w.” From another database someone suggested a similar situation a long while back in making a separate tbl with just the days of the week & the number corresponding with the weekday: Sun 1, Mon 2, etc.

Then in a qry I can join the 2-tbls & take the WeekdayNum from one tbl (WkNm Tbl) & add it onto my first tbl. I did so, but the 2-tbls seem to be incorrectly joined because
I’m getting no results/records in my Qry.

Can anyone help me by looking at the SQL?
SELECT [Employees Days Usually Work].EmployeeID, [WkDay Num].WkNm, [Employees Days Usually Work].DUW, [Employees Days Usually Work].DyEvn, [Employees Days Usually Work].DaysWorked
FROM [WkDay Num] INNER JOIN [Employees Days Usually Work] ON [WkDay Num].WkDyNID = [Employees Days Usually Work].WkDyNID;

Thanks

[djclntn]

I figured it out.