C
chickalina
I have two tables and two queries... I am trying to figure out the best way
to set up a report to show the information I need. Here's what I got:
tbl_ideas_bank
IdeaID (primary key)
IdeaDescription
Country
Jurisdiction
Structure
Contact
BusinessUnit
tbl_quarter
IdeaID (primary key with QtrEndDate)
QtrEndDate
QuarterValue
Query 1:
Combines the two tables
Query 2:
Crosstab Query that totals that total each idea by year.
I am trying to run a year report with a pop up box asking the question of
what year to start. It would total all the line items in the table for that
year and put that value in txt_Year1. The fields txt_Year2, txt_Year3,
txt_Year4 and txt_Year5 would use Year1 and add 12 months/1 year (whatever
the calculation will be).
Then, out of those records, some are Cash, some are ETR, some are both. I
need three separate fields in the footer (or wherever it needs to be), and
calculate the totals.
Can this be done?
I posted to the newsgroup before, but I was not clear and subsequently not
receiving a response.
Is this how I should set up the report? Or should I use the tables directly?
Please let me know... I've been trying to resolve this for days and I'm
getting nowhere. I've tried using the Query for a Select Statement in the
Control Source of a text box..... using the one given to me in the newsgroup,
and the one in the SQL view of the Query.
Thanks for any help.
M
to set up a report to show the information I need. Here's what I got:
tbl_ideas_bank
IdeaID (primary key)
IdeaDescription
Country
Jurisdiction
Structure
Contact
BusinessUnit
tbl_quarter
IdeaID (primary key with QtrEndDate)
QtrEndDate
QuarterValue
Query 1:
Combines the two tables
Query 2:
Crosstab Query that totals that total each idea by year.
I am trying to run a year report with a pop up box asking the question of
what year to start. It would total all the line items in the table for that
year and put that value in txt_Year1. The fields txt_Year2, txt_Year3,
txt_Year4 and txt_Year5 would use Year1 and add 12 months/1 year (whatever
the calculation will be).
Then, out of those records, some are Cash, some are ETR, some are both. I
need three separate fields in the footer (or wherever it needs to be), and
calculate the totals.
Can this be done?
I posted to the newsgroup before, but I was not clear and subsequently not
receiving a response.
Is this how I should set up the report? Or should I use the tables directly?
Please let me know... I've been trying to resolve this for days and I'm
getting nowhere. I've tried using the Query for a Select Statement in the
Control Source of a text box..... using the one given to me in the newsgroup,
and the one in the SQL view of the Query.
Thanks for any help.
M