R
Ryan
I am wanting to run a report for all 24 branches based off one report. The
reason I need this one report is because all the data reporting will be the
generally the same, just different branch info, team info, and detail. I want
the user to be able to select the date range, a branch name, a team name, and
lastly a detail type. This will generate the total budgets for the teams, but
also broken down by branches that belong to that team, and the type or
purchase weather it came from the advertising budget or PR budget ( these are
the two types of detail). The table looks something like this.
Date Field Branch Field Team Field Detail field Amount
of Purchase
06-jul-05 Champaign Dominance Duo AD
34.99
04-jan-05 Watseka Dominance Duo PR
55.66
06-aug-05 Lincoln Lariats AD
44.77
05-Feb-05 Harrisburg Posse PR
33.56
This is a sample see why t needs to be just one parameter query? All the
field names are the same just little different data in each. Their is a
relationship between the teams and branches so the database knows what branch
belongs to what team and so on.
ANy help would be appreciated
Ryan
reason I need this one report is because all the data reporting will be the
generally the same, just different branch info, team info, and detail. I want
the user to be able to select the date range, a branch name, a team name, and
lastly a detail type. This will generate the total budgets for the teams, but
also broken down by branches that belong to that team, and the type or
purchase weather it came from the advertising budget or PR budget ( these are
the two types of detail). The table looks something like this.
Date Field Branch Field Team Field Detail field Amount
of Purchase
06-jul-05 Champaign Dominance Duo AD
34.99
04-jan-05 Watseka Dominance Duo PR
55.66
06-aug-05 Lincoln Lariats AD
44.77
05-Feb-05 Harrisburg Posse PR
33.56
This is a sample see why t needs to be just one parameter query? All the
field names are the same just little different data in each. Their is a
relationship between the teams and branches so the database knows what branch
belongs to what team and so on.
ANy help would be appreciated
Ryan