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...
Thanks KG
Yes, I believe I will have to settle with 2 different forms:
1) that will be regular with single records and with the Total for its initiatives
2) I will still keep a Datasheet Form as I show above but this one will not display this total
I will try option 1 above and let you know...
Good day CJ, The Doc Man,
Apologize if I haven't been clear enough, when I wrote "Edit All fields" the Total field shouldn't be one... let me rephrase it "all fields with the exception of the Total which should be calculated from each of the Initiatives"
And I do not need to have the total...
User will need to be able to edit all fields in that form.
Is there a way add an unbound box to a regular Datasheet Form that looks up and updates the total?
thanks
Dear CJ,
The Total drop-down will work for the all the actions Total, what we need is the Total of all the Initiatives to show in each action
I tried also the =sum([InitiativeTotal]) as control source but it is giving me an error
thanks again for your help
Please see an example below, we need the sum of all InitiativeTotal to show on the ActionTotal
ActionID 1 will have the sum of InitiativeIDs 454, 616 & 1264
thanks
I have the following related tables with corresponding fields
Actions have multiple Initiatives: one to many relationship(1 to *)
ActionsTable
ActionTitle
ActionID(1)
ActionTotal
InitiativesTable
InitiativeDetail
InitiativeID
ActionID(*)
InitiativeTotal
I also created a forms for both of...
Thanks Pat, CJ_London,
As mentioned my intention is for the next step is for these numbers to be joined to the ActionsTable under the field InitiativeTotal matched by the ActionID... I understand it is not good practice to store these calculations there but it is needed for visibility...
Could...
ok, I edited as per below
SELECT Actions.ActionID, Sum(Initiatives.InitiativeTotal) AS TTLInitiatives
FROM Actions LEFT JOIN Initiatives ON Actions.ActionID=Initiatives.ActionID
GROUP BY Actions.ActionID;
Query just turns into DataSheet with the recap amounts (see attached)
What would be...
Thanks but somehow it did not work.
I tried it this way:
SELECT Actions.ActionID, Sum(Initiatives.InitiativeTotal) AS Initiatives
FROM Actions LEFT JOIN Initiatives ON Actions.ActionID=Initiatives.ActionID
GROUP BY Actions.ActionID
For visualization purposes it is ideal that the sum of the...
I have the following related tables with corresponding fields
Actions have multiple Initiatives: one to many relationship(1 to *)
ActionsTable
ActionTitle
ActionID(1)
ActionTotal
InitiativesTable
InitiativeDetail
InitiativeID
ActionID(*)
InitiativeTotal
Every time an initiative is added or...
Excellent... one last thing (hopefully!)
The default value in the VendorContacts Form is also defaulting to number (for more complex text ones it will be a problem)
How do you change this one to a text value?
Me.VendorID.DefaultValue = Me.OpenArgs
I tried it as follows and the default VendorID appears but it is not filtering it correctly... see attachment
DoCmd.OpenForm "VendorContacts", acFormDS, , Me.VendorID.DefaultValue = """" & Me.OpenArgs & """", acFormEdit, acWindowNormal, Me.VendorID