Re: FN-FORUM: sql question

date posted 23rd October 2006 19:10



[EMAIL REMOVED] wrote:
> I have a table where you have a list of bands - January_Band, February_Band
> etc each one points to one of four Price band fields. I want to sort the
> output on the Price for a particular month that has been input but I can't
> work out how. For some records it will Price Band 1 and for some it will be
> Price Band 2 etc. I can't work out how it can be done. It appears to be
> impossible. Any ideas welcome
>
>

I doubt that what you want to do is impossible, but if it seems it then
I would suggest that the structure of the database is wrong. Databases
should be designed to make it easy to get out the information you want
out, too many people design databases in a way that just "seems"
sensible without really considering what they want to do with the data.

If there is no option to change the structure then keep asking and I'm
sure we can come up with the solution.

Dave Fennell