My report is printing the details section twice.

[tjcinnamon]

I have an expenditure summary report based off of a query. The header is displayed once my problem is that the details section (which is just a bunch of totals or Sum()'s) is displayed twice. I have checked the query and all of the correct information is there. The totals match up. The only problem is the amount of times the details is displayed.

Anyone have any ideas, suggestions,
JOe K.

 

[dolano]

Try using SELECT DISTINCT

.[Field] FROM

 

[tjcinnamon]

are you saying instead of using a simple query designed in access use a SELECT DISTINCT.

P.S. Have you had or heard of this problem before.

Thanks, JOe K.

 

[tjcinnamon]

I just realized that my report is not duplicating the details table, it's displaying a details section for every record that is in the query. Therefore, if the query has 47 jobs in it then the details section of the report will be displayed 47 times. I'm going to have to modify the query. I may make a query of expressions.

Any suggestions still appreciated,
JOe K.