Joined: 22 May 2010
Online Status: Offline
Posts: 15
Topic: Group records with a set group size Posted: 06 Mar 2012 at 3:37pm
Group records with a set group size...
OK let me explain what im doing. My data is a list of all our workstations with the date and time their record was created in our assett tracking system.
So lets say I have 100 old workstations and I can replace 10 a week. I would like to be able to build a report that sorted the workstations by age and then group them in groups of 10 with the week they will be replaced calculated.
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 06 Mar 2012 at 5:06pm
Set up a running total to do a record count. Then use integer divide ("\" in the equation instead of "/") to divide the record count by the number you can replace in a week to get which week each computer will be replaced in.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
