Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report Not Displaying Data Correctly

Status
Not open for further replies.

mddaniels

Programmer
May 13, 2009
26
US
I have a hughe db that captures all of the information needed to create a check request based on the different type of procedures by each physician. The check request query is capturing all of the correct data, which consist of 3 different test types; holters, resting ecgs and exercise testing under a column named DATA TYPE. My problem is there is something in the report that is making the DATA TYPE combine the DATA TYPES for the 'holters' and resting ecgs' together and displaying only the word 'holter'. I've looked at the properties and cannot determine why the report will not display each DATA TYPE individually (the check request shows the count of each DATA TYPE and the total dollar amount paid for each DATA Type.
 
You should provide a small sample of records from your record source and then how they are displayed in your report. I expect you might have your display controls in a header rather than the detail section. This would be consistent with displaying "holters" and not "Resting ECGs" since H comes before R alphabetically.

Duane
Hook'D on Access
MS Access MVP
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top