I have an Access table with several thousand records. The key field is region. There are approimately 10 regions. I would like to generate one spreadsheet for each region. Each spreadsheet should have a unique name i.e. Myspreadsheet01 , Myspreadsheet02 , etc. How can I automate this process? Should regions increase or decrease to 8 or 12, I do not want to have to modify the code. Is this possible?
Thanks.
ANDRE726
Last Activity: Jul 27 '07, 07:53 PM
Joined: Jul 11 '07
Location:
-
This is a vexing problem that no one seems able to solve. Thanks for your suggestion. I will give it a try.... -
I am trying to do a side by side comparison of jobs at the two companies. Many job codes will match but the number of people in those positions can vary. In other cases, the job appears in company a but not company b - or in company b but not a. The final result should be a list of all positions in both companies with all matches and all unmatched....Leave a comment:
-
My mistake on the title - should be the same. When I try what you suggest, I get a cartesian product and now my file has many thousands of records. I've read in other forums that I should create a third "join" table to eliminate this problem - but I do not know how to make it work....Leave a comment:
-
many to many join
I have posted this question in other forums, but no one seems to be able to solve this problem. I have 2 tables - one called tblCompanyA, the other called tblCompanyB. The layouts are the same: JobCode, Name, Title. JobCode is 5 positions, alphanumric. Company A and B share many of the same jobcode numbers. However, the are some jobcodes in A that are not in B and some jobcodes in B that are not in A. I would like to create a query that would display... -
Generating spreadsheets from Access
Greetings. I have an Access table with about 8,000 records. The key field is Region. The 8,000 records are distributed over 50 regions. What I would like to do is to generate 50 spreadsheets, programmaticall y, one for each region. How would I go about doing this in code? Any help would be appreciated.
No activity results to display
Leave a comment: