thanks jon

[andrewvranjes]

hi jon,

cheers mate!

the query i used was named hose query, so i renamed it in your sql.

i also put it in square brackets bcos it has a space in the name.

thanks again jon!

kind regards,

Andrew Vranjes

 

[Jon K]

Hi Andrew,

You're welcome.

The worksheet was named Query3, so I thought the query was named Query3, too, because by default a worksheet is named after the query that produces it.

Best regards

Jon