query2excel

You have the "#" signs around the entire statement.  That will produce an error as "(finalQuery.recordcount+1" does not exist as a variable.  Type maxRows=#finalQuery.recordcount#+1 Eric /*-----Original Message----- /* /*Sent: Tuesday, April 15, 2008 3:08 PM /*To: CF-Talk /*Subject: Re: query2excel /* /*Hi Daniel, just tried this to no success :( thanks though /* /* /* /*>Have you tried putting the calculation in brackets first so that it /*>calculates and then inserts the sum? /*> /*>maxRows=#(finalQuery.recordcount+1)# /*> /*> /*>-- /*> /*>Daniel Kessler /*> /*>University of Maryland College Park /*>School of Public Health /*>3302E HHP Building /*>College Park, MD  20742-2611 /*>Phone: 301-405-2545 /*>http://sph.umd.edu /* /*