I have created query which I pulled some fields from three tables that are link together. In the design view I’ve created some extra fields to sum and place amounts based on my criteria. See below:
Future: Sum(IIf([GL]![Record Type]="Future",[GL]![Amount]))
Budget: Sum(IIf([GL]![Record Type]="Budget",[GL]!Amount))
Reclass: Sum(IIf([GL]![Record Type]="Reclass",[GL]!Amount))
Assumption: Sum(IIf([GL]![Record Type]="Assumption",[GL]!Amount))
Amts: Sum(IIf([GL]![Record Type]="Amts",[GL]!Amount
Total: Sum(IIf([GL]![Record Type]="Amts" Or [GL]![Record Type]="Assumption" Or [GL]![Record Type]="Budget" Or [GL]![Record Type]="Reclass",[GL]!Amount))
I have created another field to subtract Future from Total, ( see below) but the amounts will not populate when I run the query.
Do you have any suggestions?
Var: [Future]-[Total]
Future: Sum(IIf([GL]![Record Type]="Future",[GL]![Amount]))
Budget: Sum(IIf([GL]![Record Type]="Budget",[GL]!Amount))
Reclass: Sum(IIf([GL]![Record Type]="Reclass",[GL]!Amount))
Assumption: Sum(IIf([GL]![Record Type]="Assumption",[GL]!Amount))
Amts: Sum(IIf([GL]![Record Type]="Amts",[GL]!Amount
Total: Sum(IIf([GL]![Record Type]="Amts" Or [GL]![Record Type]="Assumption" Or [GL]![Record Type]="Budget" Or [GL]![Record Type]="Reclass",[GL]!Amount))
I have created another field to subtract Future from Total, ( see below) but the amounts will not populate when I run the query.
Do you have any suggestions?
Var: [Future]-[Total]