records not showing

[ptrifile]

I have a database that scores employee phone calls. The report I run shows the date of a "monitoring" the persons name and their score. It lists each individual monitoring and then after that it gives a total number of monitorings completed. This is my problem, if a person has more than one monitoring on the same day and the score is exactly the same it wont list that monitoring, it will however show the total count of monitorings correctly but wont list both of the monitorings. Not sure if anyone will be able to help with the info given but any suggestions are welcome.

Thanks!

Paul

 

[lupins46]

Sounds like you might have the Hide Duplicates property set for the textboxes on the detail line.

 

[ptrifile]

Thats what I suspected also, however all of the fields are set to NO. Any other ideas on what could be the cause?

Paul

 

[lupins46]

The only other thought I have is that the total count is not based on the same source as the report. Maybe the report source is selecting distinct records whereas the totals are not based on this.

 

[dhookom]

Are all the records in the report's record source? Is there any code running in the report? Is there a detail section or are you only seeing a group header or footer?

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[jjlogan]

Other thoughts -
1) Is your report data source (query) specifying no duplicates in the query property?
2) Is your data source (query) using joined tables? If so, examine the join types. One-to-one types can limit the data from a joined table if the joined field value is not in both tables. This has bitten me a few times.

Jeff

 

[ptrifile]

There is no code in the report other than very simple calculations like avg and count, if I simply run the query the records are there which tells me its something with the report.

dhookum - It is showing a header footer and detail

jjlogan - 1. Nowhere i can tell is specifying no duplicates.

2. There are no table joins being used here.

THank you both for your suggestions! any others?

THanks again

Paul

 

[dhookom]

I don't see anything wrong with your report. Have you tried creating a new, similar report to see if it has similar issues?


Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[ptrifile]

I solved the problem by adding one of the fields from the table to the query that would have different data all the time in it, such as customer number, and just didnt add that field to the report and eveything seems fine. Thanks for all of your suggestions it was greatly appreciated!!!!

Paul

 

[lupins46]

The inference I would draw from that is that the query properties were set to output unique records.