automaticbaby
Technical User
I have a table that's set up like an array:
Acct Mon APR04 MAY04 JUN04 JUL04 AUG04
AA APR x x x
AA MAY x x x
AA JUN x x x
AB APR x x
AB MAY x x x
AB JUN x x x
What I'd like to do is look at the difference between say APR and MAY in the Month column for the AA account, then look to see what the difference is between the two (and since April has passed, I want to ignore the APR04 column).
So, according to the array, there's an x in MAY04 which exists in the MAY row only, and so I want the query to return the field name (MAY04).
I have tried the unmatch wizard and it doesn't seem to work.
Is this at all possible or is there a different/better way to do this?
Acct Mon APR04 MAY04 JUN04 JUL04 AUG04
AA APR x x x
AA MAY x x x
AA JUN x x x
AB APR x x
AB MAY x x x
AB JUN x x x
What I'd like to do is look at the difference between say APR and MAY in the Month column for the AA account, then look to see what the difference is between the two (and since April has passed, I want to ignore the APR04 column).
So, according to the array, there's an x in MAY04 which exists in the MAY row only, and so I want the query to return the field name (MAY04).
I have tried the unmatch wizard and it doesn't seem to work.
Is this at all possible or is there a different/better way to do this?
