David McAfee
davidmcafee at gmail.com
Mon May 9 16:54:46 CDT 2011
So true! Let's not forget naming fields "Date, Month, Year" and "Name" :) D On Mon, May 9, 2011 at 2:50 PM, Stuart McLachlan <stuart at lexacorp.com.pg>wrote: > Advice to young developers: > > Never, ever, ever, ever , ever put spaces in the name of any field or > object. If you do, it > WILL turn round and bite you one day. > > :-) > > -- > Stuart > > On 9 May 2011 at 13:18, Heenan, Lambert wrote: > > > Ah well. Now that the live parts of my brain have engaged (this is a > > Monday after all) it is evident that what was tripping you up was the > > spaces in the query name. > > > > Instead of the SQL string :"Select * From, Project Month And Year" > > > > You really needed :"Select * From [Project Month And Year]" > > > > Lambert :-) > > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >