Search results

if you ever get this figured out I would like to see it if you could attach it here... currently I can open 97/2000/and XP.....I think you dont understand me because of your comment...5 layers the last 7 fields are empty what i am talking about is a field called level in which you would put a...

Shane_Mc, I think your understanding my thought...but I am not sure how it would allow nulls but i could see where my system is going to limit ...sub levels to how many fields you would build... I am thinking with mine that for a production line A you could have 1 or 12 or 144 or infinite amount...

I would think that you would not need a table for each line but you will have fields like id mainline levels sublevel 1 A 1 1 2 A 2 ...................... 10 A 10 11 B 1 12 B 2 13 B 3 14 C 1...

your form can have a list box to pick the emp # which in turns set the criteria in a query, the query should have all the fields you need in your letter, base a report on the query and make the report your generic letter... now the form that you pick the emp # place a button that you press to...

First let me say that I had worked out a series of queries that used crosstab queries to get totals....but the end result would not let me build a report ...no field names showed in the report wizard. I have to run 5 queries. inhouse, consultant, indirect, gov, and no expense. they all contain...

I agree with RV, you should be able clear the temp table. One comment about Paradox to Access. When doing things in Paradox there is always an easier way and less steps in Access