J
John
OK, Trying this again w/ clearer explanation. This is a
simplified example only, it is on a much larger scale.
Problem:
Must use multiple fields in multiple tables to calculate
values in a text. These tables are not related by a
common field always. I know your thinking the database
should be done differently, but I haven't seen an easier
way. So here is the scenario.
Scenario:
Sponsor Table(Key-Sponsor Name) - List of all sponsor
names, they sponsor multiple events but not all of them
Events TableS(Key-Sponsor Name)- Multiple tables for each
event with numerous fields describing that event, key is
sponsor name, including benefits to sponsor, such as
number of tickets
Event List Table(Key-Event Name) - NO SPONSOR NAME
involved in this table, it has the list of all events and
specific event info, like true cost of tickets given to
sponsors, these are unique per event.
Report:
Must generate report that looks as such:
Evt1-#Tkt Evt2-#Tkt Evt3-#Tkt Totals
sponsor1 $Tkt $Tkt $Tkt Spnr1-$Tkt
sponsor2 $Tkt $Tkt $Tkt Spnr2-$Tkt
.....
Totals Evt1-$Tkt Evt2-$Tkt Evt3-$Tkt
I need to calculate the totals to bottom and right of the
report in $ cost.
Must list every sponsor, what events they got tickets for
and the subsequent dollar value of that benefit, then I
need totals per sponsor for tickets $ value given, and
total per event for $ value given. Every event has
different ticket cost multiplier. I don't need a full
formula, but a explanation if this can be done and how to
go about it. Sorry for such a long question!
John
simplified example only, it is on a much larger scale.
Problem:
Must use multiple fields in multiple tables to calculate
values in a text. These tables are not related by a
common field always. I know your thinking the database
should be done differently, but I haven't seen an easier
way. So here is the scenario.
Scenario:
Sponsor Table(Key-Sponsor Name) - List of all sponsor
names, they sponsor multiple events but not all of them
Events TableS(Key-Sponsor Name)- Multiple tables for each
event with numerous fields describing that event, key is
sponsor name, including benefits to sponsor, such as
number of tickets
Event List Table(Key-Event Name) - NO SPONSOR NAME
involved in this table, it has the list of all events and
specific event info, like true cost of tickets given to
sponsors, these are unique per event.
Report:
Must generate report that looks as such:
Evt1-#Tkt Evt2-#Tkt Evt3-#Tkt Totals
sponsor1 $Tkt $Tkt $Tkt Spnr1-$Tkt
sponsor2 $Tkt $Tkt $Tkt Spnr2-$Tkt
.....
Totals Evt1-$Tkt Evt2-$Tkt Evt3-$Tkt
I need to calculate the totals to bottom and right of the
report in $ cost.
Must list every sponsor, what events they got tickets for
and the subsequent dollar value of that benefit, then I
need totals per sponsor for tickets $ value given, and
total per event for $ value given. Every event has
different ticket cost multiplier. I don't need a full
formula, but a explanation if this can be done and how to
go about it. Sorry for such a long question!
John