Dsum assistance (1 Viewer)

[fedebrin]

Hello,

Looking for a Macro that looks up and sums the TTM (12 trailing months) of OPEX from a different table.

In the table Initiatives I need a macro that will look up and add the 12 trailing months of OPEX from the OPEX table based on the date that it is entered.

Also, if a future date is added, that the macro will select the first available month in the OPEX table to start the 12 month sum.

 

[theDBguy]

Hi. Can you show us what you have tried so far?

 

[Pat Hartman]

You would do this with a query. If the query always is for the current day back 12 months, the criteria can be calculated by the query. If you want to have some control over the range, use a form with either a start and and end date or just an end date and the start date can be calculated by the query. The criteria will be:

Where TranDate Between Forms!yourform!txtStartDT and Forms!yourform!txtEndDT