Query Question?

[RobertK]

I have a table that contains payment data. For example;

name - Date - Invoice - Item - Pay type - Pay code
- Amount
Doe, John - 20050411 - 10025 - 01 - CH - Charge -
50.00
Doe, John - 20050411 - 10025 - 02 - IP - Insurance
Pay - 40
Doe, John - 20050411 - 10025 - 03 - WO - Write Off -
5.00
Doe, John - 20050411 - 10025 - 04 - PP - Client Pay
- 5.00

At this point we can have everything listed in a vertical format. There are
also times where there are multiple payments by a client (think weekly
payoffs of a bill). So in other words there could be one Insurance Payment
and four Client Payments.

What we are trying to do is get it into a horizontal format like this;

Name DAte Invoice Item Ptype Amount etc....
Doe, John - 20050411 - 10025 - 01 - CH - $50 - IP - $40
- WO - $5.00 - PP - $5.00

So in other words one line of data rather then 4. Unfortunatly I am an
extreme novice in Access and these data fields are all in the same table so
we are finding we are in need of equations in order to pick through the data.
I have looked at innerjoin queries or outerjoin queries but I am a hardware
tech not a software tech!

Any help is more than appreciated,

 

[Kirk P.]

There is a wizard that takes you step by step through a crosstab query (which
is the query type you need here).

Click Queries, New, select the Crosstab Query Wizard and click OK. You
want Name, Date, and Invoice as Row headers, Pay Type as a column header, and
sum on Amount. It should give you the results you are looking for.