HOW TO TAKE ONLY THE LAST VALUE FOR REPORTS? sudhir 30.09.2006 08:41:01 I HAVE TWO TABLES T1- FIELDS ARE- IDNO AND DATE OF OPERATION T2- IDNO AND FOLLOWUP DATE AND FU TIME IN MONTHS ( FUDATE-DATEOF OPERATION USING DateDiff formula... T1 AND T2 HAVE ONE TO MANY RELATION as the followup continues.. over years.. different values accumulate for the followup period for the same paerson.. for eg one person may be followed for 3 months, other person for 3 years and so on.. question is 1) how can i print a report specific to that one person only.. i imagine somewhere i will have to use " PRINT ONLY THOSE DETAILS PERTAING TO PERSON WHOSE IDNO= IDNO THAT I HAVE ENTERED " ( AND NOT ALL OF THEM!) 2) IF I CAN ACHIEVE THAT- WHAT IS IMPORTANT IS THE LONGEST FU TIME FOR THAT PERSON.. SO I WANT THE REPORT TO PICKUP ONLY THE LAST VALUE FOR THE FOLLOWUP PERIOD( AND NOT ALL VALUES) SO AS TIME GOES BY AFTER OPERATION.. FU PERIOD WILL INCREASE FOR ALL.. IS THIS POSSIBLE WITHOUT DIIFICULT PROGRAMMING? CAN ANYBODY SUGGEST MSACCESS ONLINE COURSES FOR TACKLING SUCH LEVEL?? THANKS SUDHIR -- sb

RE: HOW TO TAKE ONLY THE LAST VALUE FOR REPORTS? Joseph 30.09.2006 17:21:02 [Quoted Text] > 1) how can i print a report specific to that one person only.. > 2) IF I CAN ACHIEVE THAT- WHAT IS IMPORTANT IS THE LONGEST FU TIME FOR THAT > PERSON.. -Answer 1 You will need two forms FormT1 SubFormT2 Place SubformT2 in FormT1 linking child and master fields IDNO (This will sort T2 by T1) Place a command button to open the report. Edit the properties of 'On Click" of the command button adding : , , "[IDNO=" & [IDNO] to the DoCmd.OpenReport stDocName, acPreview line This will allow you to just send the current IDNO displayed on the form to the report. To Select just the longest Follow Up time, you will need to make a select query for that report to select the largest time/data. I do not know that exact criteria format, but with a little trial and error you can figure it out. Joseph Martinez