Thanks Victor, the UNION operator worked great. Had never heard of that one, but I'm
still learning ! Jason, thanks for your idea too, I will keep that in mind, but the
idea of creating another table didn't sound too fun. Or is there away for access to do
it for you? Or cold fusion?
Gregg
PS Only problem is I have a list of all the lakes on the top, then divides them by
state, will figure that one out, probably in my code.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
