Kaup, Chester
Chester_Kaup at kindermorgan.com
Mon Aug 31 14:16:04 CDT 2009
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 [mailto:accessd-bounces at databaseadvisors.com] 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 [mailto:accessd-bounces at databaseadvisors.com] 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 http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com