Hi,

The code is great and does exactly what i want so thank you for that.  Is there a way i can reference the #sampledata table x.seq column???  I...

Thank you Chris, appreciate the help.  Will try and get me head around this and figure out what the code is doing.  Thanks again

sorry guys this is a bit above my head. Can anyone point me to some examples ?  Many thanks

Thank very much, i clearly need to do a lot more reading.  Thanks again

Great thank you Thom A.  Which part does  if '1st  day of the the new quarter then show the last quarter - where is this in the code?' Many thanks...

complete agree arron thats why i asked if someone could briefly explain what section does what? I much prefer to understand than just copy and paste

sorry guys, which code should i being using now? thanks Thom A or drew.allen?  thanks

Thanks guys works a treat. Just for my info is there anyway someone can explain what bit of code does what in the code THOM A wrote just so i...

Thanks for the help but still getting duplicates.  Appreciate it tho

Amazing thank you so much

Sorry for the beginners question but can some help me put these 2 queries into 1. I've had a quick look at sub queries but can't seem to figure it...

should have metioned i would like to have 5 columns in total

Dealer
Tot vehi on site
Tot inspections carried out
Tot vehi on site 2
Tot inspections carried...

Thank you guys both work great

one last question on this topic guys

How do i make the 4 below exactly the same but for the previous year? I have tried to add DATEADD(YEAR, -1...