I am trying to create a database with time series data in MS Access 2010. More specifically, I have order history over 30 months.
What is the most efficient way to input this into MS Access? Currently, I have part number in the first column and months going across the first row. Is this the best way to do this?