Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Finding a Brought Forward figure (2000)

    I have a list of dates and carried forward figures (representing correspondence uncompleted from the previous date). I also need a BroughtForward column that looks at the CarriedForward from the previous date as a default. I was thinking of using the DLookup function to look at the previous date.. However, I need to exclude Weekends and any bank holidays! Any ideas, Andy!

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

    Re: Finding a Brought Forward figure (2000)

    You need a unique key field for this. See ACC2000: Referring to a Field in the Previous Record or Next Record for methods you can use to retrieve the value of a field from the previous record.

  3. #3
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Finding a Brought Forward figure (2000)

    I'm almost there myself. I've got a table listing dates and the prior working date as two separate columns. I then need a DLOOKUP to use the prior working date to pick up the previous CWD figure to use as a BFD figure. However, I can't quite get the DLOOKUP to work.. Andy.

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

    Re: Finding a Brought Forward figure (2000)

    Can you post the DLookup expression you have now (even if it doesn't work)? Thanks.

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

    Re: Finding a Brought Forward figure (2000)

    Perhaps you don't need a DLookup:
    Create a new query; add the table with the two date columns, and two instances of the table with the Carried Forward figures and dates. Link one instance to the first column, the other instance to the second column (the prior working date); add fields from the first instance to the design grid, plus the Carried Forward figure from the second instance, and give that an alias of Brought Forward.

  6. #6
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Finding a Brought Forward figure (2000)

    Excellent! I always try to avoid DLOOKUPs where possible. Andy.

Posting Permissions

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