Distributing Figures

  • Thread starter Thread starter rudwan
  • Start date Start date
R

rudwan

hi
i have Trans_Table Consist Of :
BillID
BillDateFrom
BillDateTo
BillAmount

i wish to distrbute each amount for related months
for example :
billID= 8
BillDateFrom = 12/01/2005
BillDateTo = 12/09/2005
BillAmount = 9000

i want through query to distribute the 9000 for each
related months
the requested result is query_distribute :
billID JanAmount FebAmount MarAmount
AprAmount ...... etc
 
This type of output is called a CrossTab. Access can make Crosstab queries
to create this type of output.
 
Back
Top