Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Re: Report/Query
16 views
Skip to first unread message
Message has been deleted
Salad
Dec 11, 2009, 7:29:46 PM12/11/09
to
Bill wrote:
> I have an application that keeps track of payments. Those payments
> can be applied to various fees. I am trying to figure out how to
> create a report from the following query.
>
>
> SELECT Paid.PaymentID, PaidAmt.Amt, PaidAmt.AssCatID
> FROM Paid INNER JOIN PaidAmt ON Paid.PaymentID = PaidAmt.PaymentID;
>
> I would like the report to look like this
>
> PaymentID Fine CourtCost Restitution
> 1234 $50.00 $25.00 $10
>
> The colum headings would come from the AssCat.
You have 4 fields and 3 in the select statement. If you have another
table, Asscat, why not add it to the select statement or do you want to
use lookups? Is it the column heading that differ per record? Give the
labels a name like LabelCourtCost and you can do something like
Me.LabelCourtCost.Caption = "Court Cost"
> I have an application that keeps track of payments. Those payments
> can be applied to various fees. I am trying to figure out how to
> create a report from the following query.
>
>
> SELECT Paid.PaymentID, PaidAmt.Amt, PaidAmt.AssCatID
> FROM Paid INNER JOIN PaidAmt ON Paid.PaymentID = PaidAmt.PaymentID;
>
> I would like the report to look like this
>
> PaymentID Fine CourtCost Restitution
> 1234 $50.00 $25.00 $10
>
> The colum headings would come from the AssCat.
You have 4 fields and 3 in the select statement. If you have another
table, Asscat, why not add it to the select statement or do you want to
use lookups? Is it the column heading that differ per record? Give the
labels a name like LabelCourtCost and you can do something like
Me.LabelCourtCost.Caption = "Court Cost"
Roger
Dec 12, 2009, 8:14:23 AM12/12/09
to
have you tried using a crosstab query, where every row in assCat has
been assigned to a column
0 new messages