Select Only 10 Columns Going Back

[Rickster66]

I need to create a sql statement in MS Access from only the last 12 columns a table that has has dates (the last days of the month) as the names of the columns. In actuality, each column is part of table that is sent to my office monthly. I only use one particular column and discard the rest. The columns in the table then looks like this:

2_29_2008 || 1_31_2007 || 12_31_2007  11_30_2007 10_31_2007 ...etc.....1_31_2007

I need to be able to select any month dynamically and select the last 12 months only.

Another idea is to use the whole tables but I the requirement is that the last 12 months must be gathered. What it basically shows is the number of errors made by a person, so the previous months represent previous performance.

I am very desperate, any help is greatly appreciated!

Richard

[Rickster66]

I'm sorry Richard. I put aside some time today to have a look at this and I'm quite unclear on :

1. Exactly what you want (exact is important as vague is nowhere in these situations).
2. Exactly what data I have at my disposal to start with.

I'm sure (I expect anyway) that this information is hidden in here somewhere but with 100 posts now in this thread it's a big struggle trying to dig it all up.

What I suggest you do is start a new thread and post in here when done. I will add in any links to enable switching between the two when I get the trigger of your posting in here.

Your new thread must include, as clearly (and especially accurately) as possible, the data that I will be working with, as well as a clear indication of what is required as output.

Meta-data (info about the layout / structure) for the recordsets (tables) is a requirement and must be clear and accurate. This will work much better if you can post it in the same way as I use in my example. Click on the Reply button and you will have access to all the codes I've used.

Table Name=[tblStudent]
 Field; Type; IndexInfo
StudentID; AutoNumber; PK
Family; String; FK
Name; String
University; String; FK
Mark; Numeric
LastAttendance; Date/Time

Remember too that getting this right first post will save all sorts of complications with the work and avoid having to search around every time I have a question I need answered (from the existing posts). All reference material in a single place makes life a great deal easier.

No worries, thank you for coming back. I am sorry I could not get back to you on Friday - I will start a new thread now.

[NeoPa]

New thread (Select Only 10 Columns Going Back (Calculations)) created.