On Fri, 6 Nov 2009 07:05:01 -0800, Smoki
wrote:

Yes, I wanted to say that, maybe I just didn't explain that good.
But how to send to you my query?

Open the query in design view. Select View... SQL from the menu. This will
open a big textbox with some cryptic looking text - that's the *real* query,
the query grid is just a tool to build SQL.

Copy and paste the SQL text to a message here.

It sounds like you have the field in the wrong table.
--

John W. Vinson [MVP]