musclecarlover07
Registered User.
- Local time
- Today, 03:50
- Joined
- May 4, 2012
- Messages
- 236
I have a simple database that I need help with a Dlookup issue. Basically this database is used as a tracker for Pie in the face. You put the players name in then you put how much money is placed on that person. So far everything in this aspect works. I have a secondary sheet "Sheet1" This has how much each vote is. So 1 vote $.25. When you give a $1 you get 5 votes. So you cane never get 4 votes. Sheet 1 is my look up sheet. I need help with the DLookup. When I put an amount in the "AmountAdd" field then hit "Add" button I need it to look up how many votes and keep a running total of how many votes were placed in the "TotalVotes" field. I keep getting a data mismatch error.
This is not the final product. This is something threw together real quick while testing. The actual copy is being used. I did not make a backup copy.
This is not the final product. This is something threw together real quick while testing. The actual copy is being used. I did not make a backup copy.