Mick being Mick Taylor:
I have thought a long time about this one and at the risk of opening old wounds will respond:
Hello Forum members, just joined and need some help. I have inherited a database from my predicessor (Rich) and while it works brilliantly, there a few queries that don't seem to function correctly
Database is a Music Preference and the problem areas seem to be
1 - From a series of dropdown boxes, can select Band = Fleetwood Mac (Blues period) and Favourite Guitarist - Options available are Eric Clapton, Peter Greene or Mick Taylor. No matter what option is selected, Mick Taylor is the value that gets stored in the table
2 - Number of Hits, again from selection box, select Rolling Stones but some data appears to be missing, for a number of years, when I know they had hits, the data is not showing up. On further investigation at table level, I have discovered that the missing hits have been attributed to Mick Taylor!
3 - Compare number of hits between artists - select 1 Jimi Hendrix, select 2 Mick Taylor and because of above anomalies, Mick Taylor wins!!!
Have checked everywhere I can think of as to how Rich pulled off this sleight hand, but can't figure out how he did it
Any assistance greatfully welcome