sql server - Access SQL: solving error 3612? -

i'm trying create report on ms access. query originating report following:

select t1.[order], t1.[hours], t1.[hours]/(select count(*)  t2 t2  cstr(t1.[order]) = cstr(t2.[order])) espr1 t1; 

an example of data tables are:

t1.[order] | t1.[hours]
1 | 100
1 | 100
2 | 300
2 | 300
2 | 300

t2.[order] | t2.[hours]
1 | 100
1 | 100
2 | 300
2 | 300
2 | 300

t1.[order] , t1.[hours] integer types. t2.[order] , t2.[hours] string types (please, don't ask!)

the query executed correctly. creates additional column espr1 containing partition of t1.hours (or t2.hours) depending on count of lines having same order value.

for example:

[order] | [hours] | [espr1]
1 | 100 | 50
1 | 100 | 50
2 | 300 | 100
2 | 300 | 100
2 | 300 | 100

but when create text box in report the following source:

 = dsum([espr1]) 

ms access give me the error 3612, not declares group clausole!

someone of you, experienced programmers have idea how workaround error?

---

others have same problem (see this , this), no solutions...

wupps... answer in 1 of links specified in question. necessary create query based specify in clausole query above.

that's it. ms...