F
Frank
Hi there,
I don't know if this is best added in reports or trhrough a query but I've
limited my query below to look for values TRV, USCPA and MMF and calculate
percentage allocations for each subtotal using Dsum. There is another type,
SLN which needs to be ignored completely, and I need to roll anything else up
into an "Other"category and I'm having trouble:
1) creating this other category (would this have to be through a union
query?);
2) this Other category needs to show up even if there are no values (see
example below)
Trade TypeID|Total Balance|Portforlio %|Result|
MMF|$2,060,000,000 |0.2341|PASS|
TRV|$651,000,000 |.07401 | PASS|
USCPA|$6,085,000,000 |0.6917| PASS|
OTHER|$0|0.0|PASS <-----i need this to be able to show up in the query or
report, even if empty-- it might include a rollup of
SPV|$250,000
STR|$600,000
VVR|$340,000
Any help would be greatly appreciated.
Frank
I don't know if this is best added in reports or trhrough a query but I've
limited my query below to look for values TRV, USCPA and MMF and calculate
percentage allocations for each subtotal using Dsum. There is another type,
SLN which needs to be ignored completely, and I need to roll anything else up
into an "Other"category and I'm having trouble:
1) creating this other category (would this have to be through a union
query?);
2) this Other category needs to show up even if there are no values (see
example below)
Trade TypeID|Total Balance|Portforlio %|Result|
MMF|$2,060,000,000 |0.2341|PASS|
TRV|$651,000,000 |.07401 | PASS|
USCPA|$6,085,000,000 |0.6917| PASS|
OTHER|$0|0.0|PASS <-----i need this to be able to show up in the query or
report, even if empty-- it might include a rollup of
SPV|$250,000
STR|$600,000
VVR|$340,000
Any help would be greatly appreciated.
Frank