help needed!

2003-11-25 Thread Dominic Hayhoe
Hi, I think everyone is misunderstanding my problem as perhaps I didnt phrase it very well. I need to add a new autonumber field to my db, but I need to make sure when the numbers go into the field they are in the order of one of my other fields that is a date field. i.e. I have a field which s

help needed!

2003-11-25 Thread Dominic Hayhoe
Hi, I need to add a new auto field to my db, but I need to make sure the records are listed in order of one of the other fields first which is a date field. Any ideas how I do this would be greatly appreciated! Thanks. D.Hayhoe This email has been scanned for viruses. -- MySQL General Maili