maximum records

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Post example of your data and example of what you want the report to look
like from that data.
 
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
 
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;
 
Back
Top