print a montly report

[filo666]

Hi, I have a query named "Salidas" it consists basicaly in 4 columns: "Date",
"Bill number" "Type of bill" "amount"

Type of bill can be just "A" or "B", so first of all I want a report that
when you open it ask for the dates (this is done) then using the dates (ex.
may) do de following

data report from sales of: May ->(done)

"date" "type of bill(A)" "from bill number" "To bill number" "amount"_

"date" "type of bill(B)" "from bill number" "to bill number" "amount"

this need to be printed as just one line, no two, but because space reasons
I put like is shown.

Now, I have almost everithing done because in record source I wrote:
SELECT Salidas.date, Min(Salidas.[from bill number]) AS
MinOfBillOrder, Max(Salidas.[o bill number]) AS MaxOfBillOrder,
Sum(Salidas.[amount]) AS SumOfBillAmount FROM Salidas GROUP BY Salidas.date;

Now. My problem is: How to tell acces that I want a sort of filter, so when
the report is for bill numbers type "A" just put in the date the amount sum
of the bills type "A" and the "from bill number" "to bill number"; and so on
for type "B"

Any suggestions will be thankfull.

TIA