eric.l.bohon
Board Regular
- Joined
- May 8, 2006
- Messages
- 149
ALL
I am having a issue trying to get the percentage on a particular thing. This is what I have:
I have two tables:
tblFYTravelTarget-which only has one entry in it and is how much money we have to spend for the whole year.
tblTravel-which has all the people that have travel over the place and the cost of those trips.
I have created a query which sum's the data from the tbleFYTravelTarget. I have another query that sums of the estimated total from the tblTravel. When i create another query with the expression: [sumofestimate total]\[sumoffy 11 interim travel target], I get a percentage of 0.00%. Any help on this
Erick
I am having a issue trying to get the percentage on a particular thing. This is what I have:
I have two tables:
tblFYTravelTarget-which only has one entry in it and is how much money we have to spend for the whole year.
tblTravel-which has all the people that have travel over the place and the cost of those trips.
I have created a query which sum's the data from the tbleFYTravelTarget. I have another query that sums of the estimated total from the tblTravel. When i create another query with the expression: [sumofestimate total]\[sumoffy 11 interim travel target], I get a percentage of 0.00%. Any help on this
Erick
