Tournament Brackets
in [Tables]
|
From: Jack Sprat Jack on 17 Mar 2010 21:24 I developed a table that includes 245 records (competitors) for an upcoming Taekwondo Tournament. Along with the table I also developed a form, query and report. All works fine. My challege is to develop a report that shows the results of the query in a "Tournament Bracket" format, i.e., competitor A versus competitor B with the winner advancing to the next round. Can anyone help me in this last step? To make it even more challenging I was wondering if the bracket format could be loaded as a function of the number of results found in the query?
From: J_Goddard via AccessMonster.com on 19 Mar 2010 12:18 Hi - I don't see where you record the results of the matches. You have a table for the competitors, but you will also need one that has Competitor A, Competitor B, Result,..... You can't create the diagram (report) without it. What do your form, query and report do that are working fine? John Jack Sprat wrote: >I developed a table that includes 245 records (competitors) for an upcoming >Taekwondo Tournament. Along with the table I also developed a form, query >and report. All works fine. > >My challege is to develop a report that shows the results of the query in a >"Tournament Bracket" format, i.e., competitor A versus competitor B with the >winner advancing to the next round. Can anyone help me in this last step? >To make it even more challenging I was wondering if the bracket format could >be loaded as a function of the number of results found in the query? -- John Goddard Ottawa, ON Canada jrgoddard at cyberus dot ca Message posted via http://www.accessmonster.com
|
Pages: 1 Prev: Referential integrity and updating primary key Next: Change blanks to 0 (zero) |