Fiscal Calendar Table Query ?

[chelseaaa]

Hello EVERYONE!

I need help writing a query to grab the Fiscal period based on my Fiscal Calendar table. I am not at all experienced with SQL and wanted to see if you guys have any pointers on where I should go with this.

I need to create Month, Fiscal Year, Qtr, and Period columns to match with the dates from the Calendar Table based on the data in the Purchase Orders Summary.

I have attached the database with the calendar and the data set that I am suppose to match it to. If you could please show me how/where to link the two tables together in a query, I would greatly appreciate it !

Thank you in advance.

 

[JHB]

You haven't any field with date type in the "Orders Summary" table, it is your first point to fix.

 

[chelseaaa]

I now have a date field that I want to use. I really appreciate your help with this.

 

[JHB]

I now have a date field that I want to use. I really appreciate your help with this.

Not in the attached database, in the table "PO Summary" [Receipt Date] need to be a date type field.