Rob,
I will explain my purpose for your understaning of what I am trying to achieve. I want this report to link to my excel workbook that I use everyday to audit all my closed register. I then use this information for my import of journal entries into my accounting package in Simply Account.
This is the query I think. I basically tried to convert an old Quicksell
2000 file to RMS format. To do want I want.I have re done the RegAnaly Report and revised to Match Z Reading since not all the Items listed on Z Reading Appear in RegAnaly. I call It Consolidated Register Analysis Report.
I have created a Sales Tax Summary Report for Crystal.
I want the All departments to list the sames way they do on Z Reading. My Report works right now but only the departments names and dollar amount with sales greater than $0.00 appear in the list on the report.
I how this was what you were referring too
SELECT TransactionEntry."Cost", TransactionEntry."Price", TransactionEntry."Quantity", Transaction."Time", Department."Name" FROM ((CupoloRMS.dbo.PUBLIC_TransactionEntry TransactionEntry INNER JOIN CupoloRMS.dbo.Item Item ON TransactionEntry."ItemID" = Item."ID") INNER JOIN CupoloRMS.dbo.Transaction Transaction ON TransactionEntry."TransactionNumber" Transaction."TransactionNumber") INNER JOIN CupoloRMS.dbo.Department Department ON Item."DepartmentID" = Department."ID" ORDER BY Department."Name" ASC, Transaction."Time" ASC