Assign blocks of rows ???

[AidanCambel]

Is there a way to say "ok, first 200 rows are reserved for (this product), next 200 reserved for (next product), etc, etc???

blank rows are fine... i just need to know if it can be done and how.

thanks.

 

[tlbroadbent]

I suppose you could create records with just a primary key but there is no reason to reserve rows in a relational database. Design the database properly, pay attention to the primary keys of each table, add rows as needed and order them as you want when displaying or reporting them. Terry

http://members.home.net/tlbroadbent/sqlarticles.htm

"I'm not dumb. I just have a command of thoroughly useless information." - Calvin, of Calvin and Hobbes

 

[AidanCambel]

I tried to not go into great detail because its rather confusing, but I do need to reserve rows. The reason is, the final report I am working with is an excel report that performs a myriad of calculations for our F.A. Until I can get to where I can built the report completely from Access, I have to continue using this report. It has a sheet where I have to take and cut and paste into a section all of the info pertaining to a product, and the next product goes in another section, etc. The reason is that a calculation sheet looks to certain areas on the first sheet - and it has to keep product information seperate. I was trying to automate this step at least until I could build the whole thing in access.

 

[MichaelRed]

For $0.02, I would advise you to develop the db app independently and get it "working" properly. Continue to use the Excel (UGH!!) thinggy as it is until you have the db app which creates "acceptable" reports. Then import the Excel "Information" and do a switch.

For less than $0.02, just don't read my advice!


MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over

 

[JoeMiller]

I agree with Michael, going down your road to a "partial job" will lead to a db that you'll have to do over again. If it's working now, don't rock the boat. Joe Miller
joe.miller@flotech.net