Recent content by Franknstuff

Age There is over ten years difference between me and my wife. The one thing that has kept us together is that I know what sacrifices I was giving up and just descided how important they where and whether I could live with it. Don't look back.

Problem The problem is that there maybe several possible combinations which would throw off later calculations. I really did'nt mean remove numbers, but ignore them. subtract 500 from 700 any number above 200 can be ignored. subtract 100 form 200 any number above 100 can be ignored.

Maybe You can mathmatically remove all numbers larger than the result as you go. This reducing the possiable combinations. A statistic analisys, or a math prof. should be able to give you an answer.

Hope I don't get into to much trouble Here is a sample database. I used the Analyze Table in Access to split the data. What I have problems with is appending another file to the three existing tables?

I can't Your asking more than I can give. If you need more than thanks anyways.

Ok The rows of data have to relate to each other. I'm not asking for someone to do it I'm just asking what direction should I take. There seems to be little information on how to import and distribute data into tables while keeping the data integrity. All I want is to import data and distribute...

no This fist question I would have is are LM339's always equal to ICLM339, etc.? No. This is where I ran into issues later.

Thanks for responding The data is: Device: Reference: Internal Name: radio R1 RES10k radio U2 LM339 radio R3 RES10k...

Do to recent forum talks, I've been questioning my own DB structure. The question is I import large data blocks which have duplicate names. Name RefDes Internal Name LM339 U1 ICLM339 LM339 U2 ICLM339 RES12 R3 RE12F I know I should split this into multiple tables, but...

Database I'm making a DB for manufacturing. Inventory tracking, Ordering, Pick & assembly reports, Datasheets, Mod's, Vendor lists, Cost tracking, P.O.'s. That anybody can use. I have the structure in place, I'm just getting all the forms and Reports together. It's a lot smaller since I...

Good Luck See what I mean.

Good luck Good Luck Pauldohert, Once they get going its real hard to get any answers that "You" asked for.

Ok I wasn't sure how envolved this DB venture was going to be, so I asked what is a Average DB size? When Mike answered 3000 tables I was having doubts about continuing. Then Pat gave me a nice average of her DB's then things starting to look better and when KKilFoil gave about the same general...

Slowly getting there. Thanks KKilFoil for your DB count. Looks like I'm going to be around the same size. So cool!

Sorry I did a search first , but only looked at a few. Went back and read more. Found my answer Thanks.