Simbi logo white is a talent-exchanging network. More »
Join the TribeYou start with 100 once you join and offer a service.
Michael is requesting

Microsoft Access 2013 Help

60


60 simbi for fulfilling my request - Virtual OK - Posted Sep 11

I have a database that I am trying to get up and running for a club I run. We are a fantasy wrestling group. We currently have 10 participants. Tables I currently have in are as follows:
* Participants (Data) (1 record of 10 entered)
* Wrestlers (Data) (1 of 10)
* Shows (Validation) (complete)
* Matches (Validation) (complete)
* Finishes (Validation) (complete)
* Points (Data, uses three prior for validation) (complete
* Master Data Table (Using all tables plus a multiplier, if needed, depending on the match type) (not yet started)

The Points table uses data from Shows, Matches, and Finishes to show every possible outcome for our league. What I don't put in that table is a multiplier for certain type of matches, since that can be any numerical value, and only in very specific matches (rare, but still need them to properly calculate points).

The Master Data table should have the Date of the event, Shows.ShowType, Matches.MatchType, Finishes.FinishType, Subtotal (ShowValue * MatchValue * FinishValue), Multiplier (Numerical, Double, Default =1), and Total Points (Subtotal * Multiplier). Furthermore, The Subtotal Field should look up the strings in the appropriate field, find the one and only record that matches it in the Points table, and return that value there. I also need the tables to properly link up in the 1 to many relationships that exist between the tables... I just can't quite get them to work out that way.

The way the Shows, Matches, and Finishes are configured are the way they must be, in order for the Points table to properly calculate the points. I do have a copy of the database I can send over, and once I get this figured out, I should be able to get myself the rest of the way done with the database to suit my needs.

I'm fairly certain a DLookup or ELookup would do the trick, but I haven't ever dabbled with Visual Basic, and would have no clue how to go about doing it right.

I work from 2p to 11p Mountain time (4p - 1a eastern) Monday through Friday, so I may be delayed in getting back to you send me a message during that time. Simbi price is flexible.


Reviews of Michael


CJ received Help with Hard drive recovery from Michael
Oct 10, 2016
Michael was great, to the point, and gave me a great resource.
Jennifer provided Help with Microsoft Access 2013 Help for Michael
Sep 15, 2016
Michael was very easy to communicate with, and had a good idea of what he needed...just unsure about how to complete it. I am glad I was able to help,... and would be happy to work with him again. Highly recommended!show more
Jay provided Unit of Spreadsheets and formulas for Michael
Jul 30, 2016
Perfectly nice guy, easy to work.
Join the TribeYou start with 100 once you join and offer a service.

Michael's services


Microsoft Access Database Creation
VeteranHelper
I'm happy to share what I know and get help where I need it! I feel this is a great opportunity to get and provide help without using traditional money. This is getting back to simpler times where ...
View

Microsoft Access Database Creation

Paper Review
VeteranHelper
I'm happy to share what I know and get help where I need it! I feel this is a great opportunity to get and provide help without using traditional money. This is getting back to simpler times where ...
View

Paper Review

Math Tutoring
VeteranHelper
I'm happy to share what I know and get help where I need it! I feel this is a great opportunity to get and provide help without using traditional money. This is getting back to simpler times where ...
View

Math Tutoring

Michael's requests


Michael is requesting
Cell Phone Unlock
I have a phone from Metro PCS, an HTC. It doesn't support moving apps to my SD card, and with the numerous apps I can't get rid of, I cannot do a system update. I would like to get the phone unlock...

I'm happy to share what I know and get help where I need it! I feel this is a great opportunity to get and provide help without using traditional money. This is getting back to simpler times where ...
Michael is requesting
Cell Phone Unlock
I have a phone from Metro PCS, an HTC. It doesn't support moving apps to my SD card, and with the numerous apps I can't get rid of, I cannot do a system update. I would like to get the phone unlock...

I'm happy to share what I know and get help where I need it! I feel this is a great opportunity to get and provide help without using traditional money. This is getting back to simpler times where ...

About Michael Brinkley

Married with two children, strong with math and computers. I've tutored math in college, and I'm a material handler at a manufacturing plant. I'm originally from Milwaukee, Wisconsin, now living in th...e Denver suburbs. I'm friendly and helpful to a fault, but don't take too kindly when that is tried to be used against me. Happy to be in an area where a car isn't fully needed, and able to get exercise to and from work by riding my bicycle show more

Open to other proposals
Michael Brinkley is looking for:
  • Just for Fun
  • Cheap & Easy
  • Gaming
  • Children's Tutoring
  • IT/Support
  • Classes & Webcasts
  • Tutoring & Mentoring
  • Learning
  • Business