Hi Sean,
I typically simplify and test. Consider removing the Group By and check the results. If that isn't enlightening, then remove the criteria and test. If you still don't understand, copy some data to Excel and use the data tools there to check the values of XYZ.
Duane
From: Sean Cooper
I have a summary query which groups on several fields and then sums several other fields.
If I add another column XYZ and "Group By' that column everything looks good.
if I then change XYZ from a "Group By" to a "Where" column, and add criteria ="teststring", everything still looks good. ie it correctly only sums data where XYZ has the value "teststring"
if I keep XYZ as a "Where" column, but change the criteria to <>"teststring" though it now only sums columns of XYZ that are blank. ie it eliminates all data where XYZ has and value not just "teststring"
Any ideas?
Tidak ada komentar:
Posting Komentar