Problems with Query in a Subform

From: Kris L. (L._at_discussions.microsoft.com)
Date: 07/02/04 

Date: Fri, 2 Jul 2004 10:33:01 -0700

I have a very simple Query that displays averages for the columns of my table.

The query, when pulled up independtly, works fine.

However, I have the query placed in a Subform inside a main form, and when it pulls up there the fields all show "#Name?"

Also note that when I pull up the Subform independently, it displays as it should.

Any help would be greatly appreciated!