As an alternative to the other suggestion you might consider retrieving the data from the data store so it is already sorted.

Depends on the installer that the CR-engine uses to install. Which installer are you using? There's info on the merge-modules on MSDN[^] :) Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

The installer every time was telling me that the installation failed and I did not know the reason however finally I got the solution the .exe package I was trying to install seems to be not complete as I download another one from microsoft site and when I tried again it worked fine.

Have a look at SQLserver localDB. http://blogs.msdn.com/b/gaurav/archive/2013/12/21/deployment-of-sql-express-localdb-on-iis.aspx[^]

so basically you have this? DEED_NR START_SHARE END_SHARE 1             1                     50 2             1                     25 3             1                     75 If you need get them out the result should be 1 - 150. If that´s the case you could use the SUM function: Select sum(END_SHARE) from DEEDS if your START_SHARE = END_SHARE+1 (1-49, 50-74, 75-154 eg) of the previous record you just need to select that last record of the deed containing the shares. Select END_SHARE from DEEDS HAVING DEED_NR = max(DEED_NR) --(not sure if a having works without a group by, but there are other constructs doing similar things.) hope this gives you an idea. V. (MQOTD rules and previous solutions)

Hi, I think this link is useful for you. "Cloud Computing for Beginners"

The fingerprint device is working that way. It is manufactured with that switch button. So if the employee of a given shift was about leaving while the security guys did not change the in/out state of the fingerprint device and that employee put his finger he will have 2 records each with in state and when reading the data this employee considered did not record leaving state. On the other hand, if the employee of a second shift came before his shift start time and the security guys did not switch the device from out state "as they changed the in state to out state at the end of the first shift" and that employee puts his finger so the final result that this employee has 2 records with a leave state. Such matter of wrong records is a case sensitive as the company will depend on the data in calculating the overtime and in salary discount(s). I hope my idea is clear now. The shift 1 and shift 2 begins and ends on 08:00:00 AM - 04:00:00 PM and 06:30:00 PM - 08:00:00 AM on the next day.

You're welcome :) Full-fledged Java/.NET lover, full-fledged PHP hater. Full-fledged Google/Microsoft lover, full-fledged Apple hater. Full-fledged Skype lover, full-fledged YM hater.