Search results

That yielded: DateOnly SumOfTransTotal 20051213 5.12 20051213 5.12 20051213 5.12 20051213 5.12 20051215 1.15 20051215 1 20051215 0.12 20051215 6.56 20051216 19.14 20051216 12 20051216 8.16 20051217 11.11 20051219 9.68 I have never scene a dataset behave like this. What could cause this? I...

I attempted to translate your suggestion into my database with the following code: SELECT Transactions.Date, Sum(Transactions.TransTotal) AS SumOfTransTotal FROM Transactions GROUP BY Transactions.Date, Format([Transactions.Date],'yyyymmdd') ORDER BY Transactions.Date...

I cannot see a time when I open the table. However, I also wondered if this was the problem. Is it possible to use a cdate command in the query to make sure it is a short date before it groups? I have heard of this but I don't know exactly how to do it or if it will work.

I am having a problem that I hope has a very simple solution that I am somehow overlooking. I have simplified my query for the purposes of this question. I have a query that only get the date and amount of a transaction. I want to group the information by date and have the transaction amount...