Hi,
I have a table which calculates the number of days in a transaction as [EndDate]-[StartDate] as numdays
I have another table with time intervals eg:-
1 Overnight
7 1 Week
30 1 month
90 3 months
How do I join these two table so that I can return the time interval based on numdays
Thanks
Phil