Search results

  1. telstar

    Solved Find last but one date

    Morning all. Sorry I have not replied in this thread as I have been away for a week. Just to let you know that I adapted arnelgp's code slightly which now gives me all of the information that I needed. Thanks to everyone for your help.
  2. telstar

    Solved Find last but one date

    Hey, thanks arnelgp, that looks to be doing what I wanted. I'll have a play around and let you know how I get on
  3. telstar

    Solved Find last but one date

    Thanks June7 - will take on board your comments and I will have a play around with your code and let you know how I get on.
  4. telstar

    Solved Find last but one date

    Arnelgp - it's in the T-Chartpositions table but I need to extract it in a query. I am trying to get something looking like the attached, I can work out Entry Position (First of SongPosition), High Position (Min of SongPosition) Weeks in Chart (Count of Song Position) - but stuck on Previous...
  5. telstar

    Solved Find last but one date

    Sure, thanks jdraw. Database with sample data attached.
  6. telstar

    Solved Find last but one date

    Thanks June7. I have previously looked through that page on AllenBrowne.com, but i can't get my head around sub-queries on multiple tables 😞
  7. telstar

    Solved Find last but one date

    Hi guys, been struggling with this for a while, wondering if anyone can help me. I have set up a music pop charts database with the following relationship I am producing charts for each week and have managed to write a query to get various positions for each song, eg entry position, highest...
Top Bottom