Trying to make spreadsheet into database

  • Thread starter Thread starter Frogfather
  • Start date Start date
F

Frogfather

I currently have a spreadsheet tracking votes on legislation in a matrix type
format. It is something like this

Bill Name member 1 member 2 Member 3
Bill 1 Y Y
y
Bill 2 N Y
N

Only with many more members and bills. I want to bring this into Access so
that i can create reports by both Bill and by member - linking it to tables
with bill descriptions and member profiles. I think what I want is a table
like this:

Bill Name Member name Vote
Bill 1 member1 Y
biil 2 member1 N

I don't know how to get from the 1st table to the 2nd table, however.
Perhaps there is a better way to get what I want, but I am hoping for
suggestions.
 
You design is correct. That's how you do it in Access. Now you just need
to transform you data into your normalized structure. Fortunately, on my
website (www.rogersaccesslibrary.com), is a small Access database sample
called "NormalizeDenormalize2k.mdb" which illustrates how to do this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
I have tried using the normalize function but get an error ("Run Time error
3265, Item not found in this collection"). It appears at:

If Not IsNull(rs1("Value" & i)) Then

Any idea how to troubleshoot that.?
 
Back
Top