Comparing data between 2 tables

  • Thread starter Thread starter SHETTY
  • Start date Start date
S

SHETTY

Dear Friends ,

I have 2 querries viz qrybilllog & QryBudget

qrybilllog is summury of state wise billing recorded for a period -with
fields billed_date, bill_Amount, Branch_Name

QryBudget is summry of state wise budget -with fields Budget_Date,
Budget_Amount, Branch_State

I want to compare state wise billing recorded agaist branchwise budget like
%ge of budget achieved in a given period

Please guide me how to solve above problem
I am looking for a consolidated/comparitive report like this

Branch Name Month BdgetAllotted Achieved %ge of budget
Branch1 April'08 0 0 2
Branch2 April'08 0 0 0


Please advise

Thanks

Ramesh Shetty
 
I want to compare state wise billing recorded agaist branchwise budget like
%ge of budget achieved in a given period
What are your periods? On a monthly basis, quarterly?
What are the three separate numbers following April'08?
 
Back
Top