I've been messing with this all weekend and am stumped on how to do this.
I have a primary key comprised of three fields: Vehicle, type, and date. This key has a 1:1 relationship with an allocation amount.
I have created a query that lists all allocations for a given effective date, and now need to create a query that generates porportion output. For example, what porportion of all money allocated for type A is dedicated to Vehicle 1.
The output of this query will be used to create a second query (which on paper looks like will work) that will automatically calculate how much money should be dedicated to each vehicle/type combo when a total amount is entered.
I have tried several combinations in the build function to no avail. Does anyone have any ideas on where to start?
I have a primary key comprised of three fields: Vehicle, type, and date. This key has a 1:1 relationship with an allocation amount.
I have created a query that lists all allocations for a given effective date, and now need to create a query that generates porportion output. For example, what porportion of all money allocated for type A is dedicated to Vehicle 1.
The output of this query will be used to create a second query (which on paper looks like will work) that will automatically calculate how much money should be dedicated to each vehicle/type combo when a total amount is entered.
I have tried several combinations in the build function to no avail. Does anyone have any ideas on where to start?
