Specific to general columns

[SysDupe123]

I'm stuck trying to figure out if this is even possible.
What I'm trying to do is take a table with 12 months, Jan, Feb, Mar,... and so forth and be able get the data from the first month with a value greater than zero.
In the end, I'll have a new table with 1st month, 2nd month, 3rd month, etc.

Can this even be done in a reasonable timeframe?

 

[PHV]

Have a look here:

http://r937.com/relational.html

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[MallardVHS]

Hi SysDupe123,

Dates are amazingly powerful tools for sorting info, but not if they are used improperly. Search the TT Fora.

If you aren't too far along yet, please reconfigure your app. Dates into one field - THEN you can sort as you wish. In Access, in Excel, in your spare time...

I know this probably wasn't much help, but Good Luck!
Don

[blue]_____________________________________________________
A really cool handle might mean you sleep-walked to the fridge.[/blue]