K
Kelly 1st
Hello!
Could someone help me with this simple query..
I have written a query that should sum 3 particular £ columns which works
fine...
I've added a 4th column that specifies what date i want to sum from using
">[forms]![Tpatih]![monthdate]"...
However if i leave the total field (for the date column) as Group by, the
query returns individual entries rather than a sum, if i use sum, the query
won't run!
If someone could help, i'd be very grateful!
Many Thanks
Could someone help me with this simple query..
I have written a query that should sum 3 particular £ columns which works
fine...
I've added a 4th column that specifies what date i want to sum from using
">[forms]![Tpatih]![monthdate]"...
However if i leave the total field (for the date column) as Group by, the
query returns individual entries rather than a sum, if i use sum, the query
won't run!
If someone could help, i'd be very grateful!
Many Thanks