Search results

Thanks! That did it! Thanks!

I am using a crosstab query for a report. In the crosstab query I have the column header being the date, and then then the Type of Toll is the other header going long the Horizontal top of the crosstab. The customer sometimes hasn't entered all the types that should show up on the report. So...

Got it I got it to give a null value by putting the sum within the Nz function, i.e Nz((Sum([Toll].AMOUNT)),0). However when I go into the query the numbers don't come out as Currency, even though the format of the field within the query was set to Currency format. Any suggestions?

Thanks The Crosstab was the way to go, the only thing is that for some reason the Nz() function is not converting null values to 0. Here look at the SQL. TRANSFORM Sum(Nz(([Toll Expenses].AMOUNT),0)) AS SumOfAMOUNT SELECT [Toll Expenses].[TRANSACTION DATE], Sum(Nz(([Toll Expenses].AMOUNT),0))...

Thanks Hey Harry, thanks alot, the idea with a little tweaking worked. i really appreciate the help. :)

Here SELECT DISTINCTROW Orders.OrderID, Format$([Orders].[Order Date],'Long Date') AS [Order Date By Day], Orders.UnitNum, Sum([Fluids #2 Qry].[Sum Of FluidsTotal]) AS [Sum Of Sum Of FluidsTotal], Sum([InHouse #2 Qry].[Sum Of InHouseTotal]) AS [Sum Of Sum Of InHouseTotal] FROM [InHouse #2 Qry]...

I need to generate a report, that sums up different transaction types. i.e., I have an ORDERS FILE, PARTS DETAILS FILE and LABOR DETAILS FILE. Within the labor category, there are 3 types: INTERNAL, EXTERNAL and MAINTENANCE. Within the parts category, there are 3 types: TIRES, FLUIDS and PARTS...