I would like the same flexibility afforded by a master calendar i.e. being able to analyse via day, week, month etc. How would I do this? Would it be best practise to create a master calendar for each field? Or, to amend each field within their original tables?
Sorry if this is vague, I hope you can understand my query.
Here is one of the tables I am referring to. It features the date fields:
[Date of Receipt]
[First Payment Date]
[Last Payment Date]
[Loan Recipient Birth Year] is also a date field but I don't think it would be necessary for it to be put into a master calendar.