|
About working with the voting records:
The vote data table can be dumped to an Excel spreadsheet. Likewise the data
from the query supporting the canned reports can also be dumped to an Excel
spreadsheet. The difference is that the table data is laid out with the voting
members and their votes as seperate fields by bill number in one record.
Member's votes are identified numerically (1, 2, 3, 4). With the query the
voting members have been combined into a single field, all votes are in a single
field (identified as text: Yea, Nay, Pass), all bill numbers are in a single
field and each record also has a record id from the table's record id field so
that votes can be grouped.
The table dump is everything in the table. The query dump can be limited by
date. Both dumps, of course, have dates for the votes but in general if you want
to manipulate the data into a web or print document it would probably be quicker
with the query dump. |