I want to create a set of tables that will hold fairly simple monthly HR data. There will be tables for different directorates/data type within the organisation.
Is it possible to reliably use the month/year as the the primary key (in format 'May-09')? This will allow queries to be run across different tables in order to make comparisons between directorates, time periods, etc.
When I initially attempted to do this, Access wouldn't retain an entered month from the past, i.e. it replaced it with the current date.
Access has some "helpful" stuff that muddies the water.
Can I just confirm - the column is date\time datatype? And you have set the format to month\year, correct?
What sort of queries will you run? Just for a specific month? Or comparing matching months year on year? Or comparing this month with last? (and so on)