Hi

I have inputted all the records from an excel worksheet of products (rows) with their respected costs and formulas.
After an afternoon of inputting I found out it takes too long to go into every record and change the month from May to June.

I think I need a script(batch) that runs and takes all the May records and inserts it as a June record. Is this possible or is there a better way? So far I have the user just change the months and insert the record but it takes too long for all the May records.

Just need some pointers to get started.
Thanks
BW

UD4
asp/vbscript
IIS 5
SQL 2000

Right mouse button on a table > Query > Update Query
After that, you just need to specify criteria for filtering (May) and new value (June).

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Hi

I have inputted all the records from an excel worksheet of products (rows) with their respected costs and formulas.
After an afternoon of inputting I found out it takes too long to go into every record and change the month from May to June.

I think I need a script(batch) that runs and takes all the May records and inserts it as a June record. Is this possible or is there a better way? So far I have the user just change the months and insert the record but it takes too long for all the May records.

Just need some pointers to get started.
Thanks
BW

UD4
asp/vbscript
IIS 5
SQL 2000


<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Viktor Farcic

TalkZone Manager