Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Fetching previous record values in a report (2003)

    How can I make the expressions used in the control source of both Testo22 and Testo85 text boxes in the RPonteNembro report of the attached mdb retrieve not just the value of the LETTUR field for the previous day but, more flexibly, the value of the previous available day so as to make up for possible missing days?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Fetching previous record values in a report (2003)

    Here is the control source for Testo22. You should be able to work out the other one using the same pattern.

    =DLookUp("LETTUR","pne1","Giorno=#" & Format(DMax("Giorno","PNE1","[Giorno]<#" & Format([Giorno],"mm-dd-yyyy") & "#"),"mm-dd-yyyy") & "#")

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Fetching previous record values in a report (2003)

    Thank you Hans,
    That is pure magic. <img src=/S/artist.gif border=0 alt=artist width=34 height=29>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •