Report question

[devagupt]

I have a table with many fields ( 10 fields out of which 6 are for specific product issues). Each of those 6 has a number enter in it via a form.I've created a report and dont need to display these 6 fields. Instead i would like to display the maximum number entered in the fields in a group of records ( as i would sum records based on the persons name and date). I need to display only

eg..

Name vial , stopper , seals , codes , other
Joe 2 5 7 3 5

I would like to display "Seals" in the report as it is the highest number when all of Joe's records are summed.

How would i do that? Please Help ..

 

[IGPCS]

well you can base the report on a query that is based on this table and in the Summary of that query choose from the list max it will only give you the record where the field is the max from all record

I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY

 

[dhookom]

I would normalize the table structure so that issue titles were not field names. If you want to add a new issue type, you should not have to add a field, controls,... Issue types should be data. This would allow you to create a totals query to get your values rather than calculating across fields of a record.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]