themurph2000
Fat, drunk, and stupid
- Local time
- Today, 12:32
- Joined
- Sep 24, 2007
- Messages
- 181
I apologize for this one, but I inherited this for my new job last week.
The company I work for has a database of safety cards recorded in an Access database. They use pivot tables in Excel with the data linked in from a union query in access. The reason why is because they were attempting to document all of the different checkboxes on the original form and assign them points (2 major categories, 35 checkboxes per).
This resulted in a record source from Access of almost 600,000 records. Naturally, I can't re-establish the link between the spreadsheet's pivot table and the union query in Access (and refreshing it kills the records in the pivot table).
If someone has any thoughts on this, feel free to ask me some questions. Basically, I'm looking for a good starting point. I'm working on a new method to count up the check boxes, but what I've come up with (putting a point value field for each one) may not be enough.
Lots of :banghead:going on.
The company I work for has a database of safety cards recorded in an Access database. They use pivot tables in Excel with the data linked in from a union query in access. The reason why is because they were attempting to document all of the different checkboxes on the original form and assign them points (2 major categories, 35 checkboxes per).
This resulted in a record source from Access of almost 600,000 records. Naturally, I can't re-establish the link between the spreadsheet's pivot table and the union query in Access (and refreshing it kills the records in the pivot table).
If someone has any thoughts on this, feel free to ask me some questions. Basically, I'm looking for a good starting point. I'm working on a new method to count up the check boxes, but what I've come up with (putting a point value field for each one) may not be enough.
Lots of :banghead:going on.