I’ve a report to send out via email every month from the records of 2 tables.
Record A is recorded everyday and report will be generated end of the month. I need to get the final record of the month subtract the final record from previous month. So I reference both tables using mm/yyyy and pre-recorded the mm/yyyy in the excel to populate the months for the whole year (Jan 2020, Feb 2020,…) into Record table. So when there is new record added to the Record A table, the record will also appeared on Report table according to the month.
Question: How do I hide or show some columns that reference to Report table? The thing is Record A table is also reference to another table and have to show all columns.
Record B is not recorded everyday but as and when is needed. A report will also be generated monthly together with Record A.
Question: How do I reference Record table B to Report table where the output is to select the last record (Date) and last completed record from the Record B? If I use mm/yyyy same as Record A as Ref, then only record for that month will show and the past records will not show. The records in Record B table can be many years ago eg. Jan 1999, Dec 2019, etc.