G Guest Jan 12, 2006 #1 When I try to use a field that is an addition of two Average fields I get nothing. Anyone have any insight?
When I try to use a field that is an addition of two Average fields I get nothing. Anyone have any insight?
L Lynn Trapp Jan 12, 2006 #2 Try something like this. Select (Avg(SomeField) + Avg(SomeOtherField)), Field1, Field2 From YourTable Group By Field1, Field2 -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Jeff Conrad's Access Junkie List: http://home.bendbroadband.com/conradsystems/accessjunkie.html
Try something like this. Select (Avg(SomeField) + Avg(SomeOtherField)), Field1, Field2 From YourTable Group By Field1, Field2 -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Jeff Conrad's Access Junkie List: http://home.bendbroadband.com/conradsystems/accessjunkie.html
