jeran042
Registered User.
- Local time
- Today, 04:54
- Joined
- Jun 26, 2017
- Messages
- 127
I have 2 formulas that I need to combine for a report that I am creating, the first one pull the name of the previous month:
The second one is a dlookup, Where I am trying to pull a value from the previous month.
Unsure if I am going about this the wrong way. I do not wish to have the query be the data source for this report.
Any guidance how to proceed, or where I can find some additional information would be greatly appreciated,
Code:
=Format$(DateAdd("m",-1,Now()),"mmmm")
The second one is a dlookup, Where I am trying to pull a value from the previous month.
Code:
DLookUp("Format$(DateAdd("m",-1,Now()),"mmmm")","qrySalaries","COST_CENTER= 3200")
Unsure if I am going about this the wrong way. I do not wish to have the query be the data source for this report.
Any guidance how to proceed, or where I can find some additional information would be greatly appreciated,