How to display a range of record (1-10++) from Access Database
Posted on 2004-11-19
Eg From (1-10),(11-20),(21-30)......(101-110++)
on click of 1-10 of 120
I assume, first I had to determine the total no of records in the table (based on Resource ID), then set the Maximum and Minimum number of records to display (which I am going to display on JTable using Java).
But I am not sure how I can do so. Lost....
This is my sql statement to retrieve the whole list of workstation.
SELECT workstation.[Resource ID], pc.[Pc Description], pc.[Software Description], peripheral.[Peripheral Description]
FROM (workstation LEFT JOIN pc ON workstation.[Resource ID] = pc.[Resource ID]) LEFT JOIN peripheral ON pc.[Pc ID] = peripheral.[Pc ID]
WHERE (((workstation.Active)=1) AND ((pc.Active)=1));
This is the statement I using to retrieve the total number of resource records
SELECT count(*) AS [Total Resource]