maximum records

[Guest]

in my query each record contain 5 fields, and for each group of records 3
fields are similar and 2 fields change.now i want to make a tabular report of
these fields just for maximum items of changeble fields.

thanks in advanced.

 

[Duane Hookom]

The most efficient method of doing this is to create a totals query that
groups by the 3 fields and displays the maximum of the others. Base your
report on this totals query.

 

[Guest]

Post example of your data and example of what you want the report to look
like from that data.

 

[Guest]

MY DATA LIKE THIS:
DOC NO TITLE REV TRANS
CT-ST-DWG-1001 TEST1 01 T-CT-AT-2003
CT-ST-DWG-1001 TEST1 02 T-CT-AT-3005
CT-ST-DWG-2005 TEST2 00 T-CT-AT-3700
CT-ST-DWG-2005 TEST2 01 T-CT-AT-4000

MY REPORT LIKE THIS:
DOC NO TITLE REV TRANS
CT-ST-DWG-1001 TEST1 02 T-CT-AT-3005
CT-ST-DWG-2005 TEST2 01 T-CT-AT-4000

 

[Guest]

Try this ---
SELECT Masoud.[DOC NO], Masoud.TITLE, Max(Masoud.REV) AS MaxOfREV,
Max(Masoud.TRANS) AS MaxOfTRANS
FROM Masoud
GROUP BY Masoud.[DOC NO], Masoud.TITLE;