link to calendar

[#1]

hi i have created a master calendar which populates dates in various formats from 2008 to 2099. i want to link the calendar to an orders table with an orders date.

how do i link the calendar to the table so the master calendar only populates dates which are joined to the order date.

Thanks

Laura

[#2]

Hi,

Try left join orders table to calender table.

better if u can post sample data.

Regards