[AccessD] NZ question

  BODY { font-family:Arial, Helvetica, sans-serif;font-size:12px;
}Moral:  Never name a field the same as a function or other reserved
word.  It may bite you even after you fix it.
 Regards, 
 Steve Goodhall, MSCS, PMP 
 248-505-5204 
 On Mon 31/08/09  3:16 PM , "Kaup, Chester"
Chester_Kaup at kindermorgan.com sent:
 Problem found. Query was actually referencing a field named date
that did not exist in an underlying table anymore. Table filed name
had been changed to a non reserved word but never the old query. 
 Thanks.
 -----Original Message-----
 From: accessd-bounces at databaseadvisors.com
[accessd-bounces at databaseadvisors.com [1]] On Behalf Of Max Wanadoo
 Sent: Monday, August 31, 2009 2:00 PM
 To: 'Access Developers discussion and problem solving'
 Subject: Re: [AccessD] NZ question
 It works ok my end, Chester
 Does date() work in your Immediate Pane if you type it in, if not
check your
 references
 Max
 -----Original Message-----
 From: accessd-bounces at databaseadvisors.com [2]
 [accessd-bounces at databaseadvisors.com [3]] On Behalf Of Kaup,
Chester
 Sent: 31 August 2009 19:55
 To: Access Developers discussion and problem solving
 Subject: [AccessD] NZ question
 I have the following as a field in a query. Since date() is a
variant why
 does the following not want to work? It wants a manual data entry.
 End_Allocations_Calc: NZ([End_Manual_Allocation_Factors],Date())
 Chester Kaup
 Engineering Technician
 Kinder Morgan CO2 Company, LLP
 Office (432) 688-3797
 FAX (432) 688-3799
 No trees were killed in the sending of this message. However a large
number
 of electrons were terribly inconvenienced.
 -- 
 AccessD mailing list
 AccessD at databaseadvisors.com [4]
 http://databaseadvisors.com/mailman/listinfo/accessd
 Website: http://www.databaseadvisors.com
 -- 
 AccessD mailing list
 AccessD at databaseadvisors.com [5]
 http://databaseadvisors.com/mailman/listinfo/accessd
 Website: http://www.databaseadvisors.com
 -- 
 AccessD mailing list
 AccessD at databaseadvisors.com [6]
 http://databaseadvisors.com/mailman/listinfo/accessd
 Website: http://www.databaseadvisors.com
 

Links:
------
[1] mailto:accessd-bounces at databaseadvisors.com
[2] mailto:accessd-bounces at databaseadvisors.com
[3] mailto:accessd-bounces at databaseadvisors.com
[4] mailto:AccessD at databaseadvisors.com
[5] mailto:AccessD at databaseadvisors.com
[6] mailto:AccessD at databaseadvisors.com