[AccessD] Need Some help

Thanks good advice. I normally don't. Jut did on this.

Steve A. Turner
Controller
Mid-South Engineering Co. Inc
E-Mail: sturner at mseco.com and saturner at mseco.com



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart
McLachlan
Sent: Monday, May 09, 2011 4:50 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Need Some help

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