telstar
New member
- Local time
- Today, 08:04
- Joined
- Sep 3, 2021
- Messages
- 7
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 position, weeks in charts etc. What I would like to do is get the previous weeks position for each song if it was in the chart the previous week. If i click on tables - T-Artist, T-Songs, T-ChartPosition, it shows the following for a particular song, so in this example would like to get the position for 29/11/1952.
Thank you - any help appreciated
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 position, weeks in charts etc. What I would like to do is get the previous weeks position for each song if it was in the chart the previous week. If i click on tables - T-Artist, T-Songs, T-ChartPosition, it shows the following for a particular song, so in this example would like to get the position for 29/11/1952.
Thank you - any help appreciated