[AccessD] NZ question

Try:

End_Allocations_Calc:
IIF(NZ([End_Manual_Allocation_Factors],"")="",DATE(),
[End_Manual_Allocation_Factors])



On Mon, Aug 31, 2009 at 12:00 PM, Max Wanadoo<max.wanadoo at gmail.com> wrote:
> 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
>