Recent content by Chopper83150

Oops, very sorry, try this one, check the report please, that is the layout I need but as you can see I cant get it to show all the data on one line per date range.. I dont even know if this is possible:confused: regards, Chopper

[ATTACH]50977[/ATTACH Here is the Db THanks in advance

Okay, but if I remove the PRODUCTID then the query just returns the total sales for the date broken down into CASH, CREDIT CARD, BANK TRANSFER. I need to get those three totals (CASH, CREDIT CARD, BANK TRANSFER) for rooms, laundry, Taxi etc for each date

This is what I want I hope that helps.. THanks Again

This is what I get

Thanks for the response. With that query i have the data that I want but i don't know how to get that data into a report with the correct formatting When I run my query; TRANSFORM Sum(Invoices.Amount) AS SumOfAmount SELECT Invoices.InvoiceDate, Invoices.PRODUCTID FROM PaymentTypes INNER JOIN...

I have been struggling with this report issue for awhile. I would appreciate any thoughts/insights. I have a table called invoices, which contains the following fields INVOICEID GUESTID BOOKINGSID InvoiceDate RoomNo PRODUCTID - contains rooms/massage/taxi/extrabed/ (lookup) Amount PaymentType -...

That worked a treat... Thanks,

HI, I am hoping for some help please. I have a table called bookings, three records within that table are; arrivaldate departuredate breakfast This Table (Bookings) is linked to the guest table via GUESTID Assuming that a guest arrive on the 5th and leaves on the 10th, I am trying to create...