Date Table with Year, Qtr, Month, Week, Day, Date

[Venkatraman]

I want to have a table with Year, Qtr, Month, Week, Day, Date from year 2000 to 2015. New to MS Access - Help - Please.

 

[Ziggy]

Explain what you are trying to accomplish, perhaps your answer may be in an "Expression".

ziggy

 

[PaddyD]

i've heard of cross posting, but not noticed someone doing it on the same board before!

http://www.mrexcel.com/board2/viewtopic.php?p=264714&highlight=#264714

...clearly, i have no idea if that's what the op meant.

 

[Ziggy]

No kidding! I hate when people don't respond to their posts

 

[Venkatraman]

I have to store Year, Qtr, Month, Week, Day, Date in a table, the Primary Key is Date - this table will be the main source of reference for all orders coming in.

 

[PaddyD]

in the linked thread, I gave you an excel procedure for this. once done, just bring the table into access...