RE: QoQ is killing me

2006-09-14 Thread Ben Nadel
You can't use the function LEFT() in query of queries. Query of queries only allows for a few functions such as UPPER() and LOWER() for example. Can you perform the LEFT() call in the original Query before it gets to CF? ... Ben Nadel www.bennadel.com Certified Advanced

RE: QoQ is killing me

2006-09-14 Thread Nathan C. Smith
Thank you! That is what I will do. -Nate -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Thursday, September 14, 2006 10:43 AM To: CF-Talk Subject: RE: QoQ is killing me You can't use the function LEFT() in query of queries. Query of queries only allows