HOW TO TAKE ONLY THE LAST VALUE FOR REPORTS?

[Guest]

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

 

[Guest]

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