Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Other Forums  MS Access  Inserting sequential numbers

Author  Topic  HitenB Starting Member 11 Posts Posted - 2008-07-15 : 03:17:51 Hi, I'm a newbie on this forum. Glad to join you, My first question: I have a table in which i would like to insert the numbers between 1 to 207. I have a field called ActionNo which needs to have values from 1 to 207. This is appicable for values where the field called HATSRecordNo is greater than 1310. I was trying to write this as a union query Any help would be much appreciated. Thanks.