Re: Multiple Column Report - esp for Duane Hookom

WOW - your response was 19 minutes after I submitted my question. Do you get
notified whenever someone enters you name in a posting?

It's not real clear when you have field names and data samples but don't
state any relationship. For instance "page break and the Second Water
District" which should better be explained as page break between [OrgID] or
some other field. I don't know what field you are grabbing "Second Water
District" from.

Indeed - the page break is tied to [OrgID].

The two tables I described are related by AcctNo - the Primary Key of
TYa1_ChartofAccts, and a foreign key in TAa1_AllAccts. It is a one-to-many
relationship.


Can you create a simple totals query that groups by district, field of
"WaterSales", Field of "residential" and displays field of "20,000" etc? If
so, reply back with the SQL view of this totals query.

Remember that the account values in [TAa1_AllAccts] are in fact already
annual totals of accounts for these water districts taken from their year end
audited financial reports. For example a record in the table is:

OrgID: 2078
FY: 2003
AcctNo: 4600
AcctValue: 547,945

By relating [OrgID] and [AcctNo] to other tables to get their related
values, this record indicates that ($)547,945 is the annual total of all
Residential Water Sales by Millview Water District in Fiscal Year 2003.

I'm not sure, but I think this structure precludes using a totals query that
would add all of Millview's Residential sales together because the number is
already an annual sum.

Also - in the current structure there is no field named "residential".
"Residential" is a field value in [TYa1_ChartofAccts]. That table's two
fields are [AcctNo] and {AcctName]. So the record with "AcctNo = 4600" has
"AcctName = Residential" as its mate.

I spent some time just now describing the actual queries I used up to this
point, but it became sort of long. I appreciate your time and don't want to
waste it. Tell me if you want to see any or all of those. There are 4 sets of
queries.

The first two sets of queries combine accounts into one value for the Income
Statement. Accounts 4610 through 4619 are Water Services, which are reported
as one line (Water Services) in the State Controller's Income Statements.
4605 and 4609 are also reported together on one line (Other Sales).

The 3rd query selects all the accounts that are not affected in the 2 query
sets above.

The final query combines the results of these 3 queries to produce the
dataset I've been using in my attempts to create the IS report.

Do you want to see any or all of those? (Sort of long as I say.)

I appreciate the help Duane.

John D


.

Relevant Pages

  • Re: Incorrect request for parameter
    ... and end date and one can then select from a list of queries. ... fact, for one query, before I had entered any criteria at all for any field, ... to see this information for all accounts whereas the other is only concerned ...
    (microsoft.public.access.queries)
  • Re: Incorrect request for parameter
    ... I realized that the queries I was having ... query, it was obviously affecting the outcome since removing this nested ... fact, for one query, before I had entered any criteria at all for any field, ... to see this information for all accounts whereas the other is only concerned ...
    (microsoft.public.access.queries)
  • Re: Moons lunar tug twice a day on Noahs Flood
    ... the flood was over, the water simply evaporated away. ... We have as evidence eye witness accounts that it rained for 40 days ... a series of worm holes, ...
    (talk.origins)
  • Re: Multiple Column Report - esp for Duane Hookom
    ... I don't know what field you are grabbing "Second Water ... District" from. ... My table that holds the actual report data is structured: ... AcctNo determines the order in which accounts are printed on the IS. ...
    (microsoft.public.access.reports)
  • Re: Multiple Column Report - esp for Duane Hookom
    ... "Accounts 4610 through 4619 are Water Services, ... audited financial reports. ...
    (microsoft.public.access.reports)
Loading