Dear All
I have looked through the timeline queries so far on your forum and have not found an answer to this one yet. I wondered if it is in fact beyond the scope of a desktop based database application.
I have recently been working on an educational project in Excel in which I have listed all the years from 3760BC to 2050 AD on the far left hand column.
Subsequent columns have the countries of the world in alphabetical order.
This enables concurrent country timelines of world history that multiple history students may add to on a shared network.
I understand, however, that once an Excel spreadsheet becomes more than 10MB in size (currently 8MB), it becomes unwieldy in Excel and have been advised to upgrade the project to a database.
My question is:
is this idea indeed beyond the scope of a database? I have an idea of how to set up a Primary Key for the years, eg 201401312000 equal to 8PM on 31 Jan 2014.
However, when incorporating BC dates, eg 2014BC, will Access be able to keep all of the BC dates and AD dates together? Is it a simple solution of having an AD table and BC table?
I have a sample in Excel that I may send any interested people.
Many thanks for your time.