Help with detail/summary report

[mx290sl]

I am trying to create an attendance report that will give in the detail the total employees absent by shift, department and date. I have this counting as it should. I am having a problem with the summary part at the end of the report this should be by department and shift. For example:

Dept Shift1 Shift2 Shift3 Total
8 14 3 4 21
11 39 4 30 79

I have tried adding a text box in the report footer with the following control sourc: =IIf([CUSTOMDATA]=1 And [HOMELABORLEVELNM2]=8,Count([HOMELABORLEVELNM2]),0). Of course I have not had any luck. I also tried creating a chart below, but because one of fields I am bringing in is memo, this will not show up in the chart. Could someone please suggest a solution. And I am a beginner at the reports. I do fair at getting queries to do what I need them to do, but have very little experience in reports. Thanks,

Shirley

 

[KenReay]

Hi

Without actually knowing the structure of your table(s),I would gues that you need a crosstab query, and a subreport based on that cross tab query

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[mx290sl]

Ken,

I failed to menttion that the query has criteria - prompts for a date range. Will crosstab queries allow this? Thanks.

Shirley