Sam, >>>>>>>>>> Does anyone know of a tool ( or what the map basic would be ) that could aggregate one table in to many little tables based on a common attribute within a field. <<<<<<<<<<
Qik_subset.mbx on teh directionsmag site will do this for you... >>>>>>>>Also does any one what the map basic would be to update an ID field with consecutive numbers until a common attribute within a field changes at which point it should recount and carry on like this down the table <<<<<<<<<<<<<< not as easy as it sounds because things like ROWID work on the base table not teh sub-query, so if the table isnt 'ordered' correctly on the defining field you will end up with out of synch rowids withinin each sub-group...(but it is do able) you just need to be sure your table is sorted correctly (AND PERMANENTLY) on the sub-query field >>>>>workspaces<<< sorry...I hardly ever use them..complete pain in the butt.... R ********************************************************************* This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments. http://www.bgs.ac.uk ********************************************************************* --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 7921
