Recent content by oXmike

Hi Paul, I'm excellent at confusing people lol... The question was really about getting normalised data to appear merged. Thanks for the link, I have utilised it and it works thanks. Gemma, They run medical clinics also where they may have 20+ students. Apparently there are rules in regards...

Hi Folks, I'm rebuilding slowly a inherited 2007 DB that has some very strange features. One area is the 'staff' table. The Pk of this table has been built using the initials of the individual members of staff. I must add, this is not an issue with the Pk, I will be adding a new Auto-Number...

Thanks for that, It has worked. As for the inherited DB. It's a mess, believe me. But the real problem is that I'm not allowed to change anything yet, just work with what I have at least till I get my feet under the rug a bit more. The person who designed it is my line manager, and I've only...

Hi Folks, Any help would be appreciated as I'm really stumped. Have just inherited a system that records absences from University Lectures for one of the departments. I am being tasked with outputting data that shows: LEFT SIDE OF THE QUERY: Every student & Every event (Done with...