I need help in multiple Invoice # displaying in my report.

[foody]

I have a report that displays invoice number with first name, last name, data and owed. An example illustrated below:

Invoice # First Name Last Name Date Owed
---------------------------------------------------


Invoice # First Name Last Name Date Owed
-------------------------

I know this is something that can be done in the report window it self and via query, but I don't know how to do it myself. Any help would be greatly appreciate it. Thanks in advance.

 

[foody]

Why am I ignored in all of my aid request? Have my name reputation became horrible? I appreciate it please if someone can help me?

 

[Smart]

If you base your report on a query that looks like this you should have the desired results
SELECT Yourtable.Invoice_no, Yourtable.first, Yourtable.last, Yourtable.date, Sum(Yourtable.owed) AS SumOfowed
FROM Yourtable
GROUP BY Yourtable.Invoice_no, Yourtable.first, Yourtable.last, Yourtable.date;

Hope this helps