Dan Waters
dwaters at usinternet.com
Sat Sep 1 14:11:03 CDT 2007
What I do is to create and test a query using the query designer. Then go to SQL view in the query window. Then copy the Select statement into a code window, and do a little adjusting so it works in VBA. The parentheses are all there. And believe me, they are ALL there! BOL! Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bob Gajewski Sent: Saturday, September 01, 2007 1:47 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Does anyone have a parenthesis highlighting tool? Hi Folks I am in need of some rather complex WHERE statements in my SELECT clauses, and was wondering if anyone knew of a tool/program that helps keep parentheses properly paired --- perhaps similar to the way that Excel uses different colors for highlighting corresponding pairs? Thanks, Bob Gajewski No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.484 / Virus Database: 269.13.1/982 - Release Date: 08/31/2007 17:21 PM -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com