I have a table of books in my DB and each page has a different serial no following each other eg. Page 9 has serial 005065 and 10 has 005066.
In my table it only gives me a range of serials as per the book, this is how my table looks like:
Book 1st_Serial Last_Serial No.of pages 1 00530901 00531000 100 2 006001 006025 25
I want to display all the serial nos. per book.
Can somebody plz help me with a hint of how i can query down to get the results i need?? Any auto-fill function I can use?
Your help will be appreciated. TQ