Putting values in different columns based on calculated intervalls

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I'm trying to do the following. I use a query to calculate the difference
between two dates for a specific invoice. Then I want each customer to be
shown on one row where I "put" the sum of one or more invoices in different
intervalls i.e. due 1-10 days, 11-20 days etc based on the calculated
differnce of dates described above. Does anyone have a solution for how to go
about making such a query.

Thanks in advance / Bell
 
Hi,

I'm trying to do the following. I use a query to calculate the difference
between two dates for a specific invoice. Then I want each customer to be
shown on one row where I "put" the sum of one or more invoices in different
intervalls i.e. due 1-10 days, 11-20 days etc based on the calculated
differnce of dates described above. Does anyone have a solution for how to go
about making such a query.

Thanks in advance / Bell
Click to expand...

A Crosstab query would be the way to do this. Do you have a calculated
field displaying "1-10 days" etc. already? If so, use it as the Column
Header of the crosstab.

John W. Vinson[MVP]
 
Hi John,

crosstab seem to be the solution. However before I can use that I need to
calculate a field displaying the intervalls. Currenlty I cant figure out how
to do that either. What I have is customer name, invoice amount, number of
days late. Have been trying a Dlookup function to convert the number of days
into a number between 1 and 5 that i could use in the crosstab but cant get
it to work correctly. Any suggestions?

Thanks / Bell

"John Vinson" skrev:
 
Back
Top