I prepared the report in access and I use group by assignto.acontract
Access generate the following query in report


SELECT assignto.empno, assignto.aposit, assignto.astrdate, assignto.aenddate, assignto.acontract, assignto.contractno, position.rec_id
FROM position INNER JOIN assignto ON position.aposit = assignto.aposit;

but above query (report) don't show all records with respective to his group by.

in the table assingto.acontract have 4 records but above query display 2 records.
same like other acontract don't show all records why ?
records are displaying less and more, it is not show acquarate records from the table. why ?
data in the table like this.

acontract contractno
---------- ---------
2016 221
2016 2002
2016 229
2016 282
2015 284
2015 2002
...
and so on..

acontract=2016 have four records it should be display in report
like this

acontract 2016
----------------
221
2002
229
282

please help how can dislay full records in access by using
group by clause

Mateen

Have you checked the original sources of your data?

Is is possible that the report is built on a query that is filetered?

Could the the report source query be built on another query or string of queries that have a filter on one of them?

Even if the report is built on a table or a query, is it possible that the report porperties itself has filtering turned on and there is a filter spec included there?

there is a difference between group by done by query
and grouping done with any reporting tool...
what is the reporting tool you are using and how do you adjust the grouping in the report???

Ahmed Ali
Software Developer

thanks for response.

thanks for response.
Yes I check the origional source of data in the table.
in the table, acontract have 4 records, hence
acontract group should be display 4 records.

I have three table, ie
assignto table fields
--------------------
acontract varchar
contractno varchar
aposit varchar
.....

employees table fields
------------------------
empno varchar
name varchar
......

position table fields
----------------------------
rec_id numeric
position varchar



I want to use group by in assignto table and on acontract field
so that each group data display separately.

I am not sure what internal property access use to filter the data.

Regards.

Mateen