Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Undefined Function NZ in expression

Status
Not open for further replies.

fredk

Technical User
Jul 26, 2001
708
US
I am receiving the following error "Undefined function 'nz' in expression - However I am not using the nz function? Here is the code where I am getting the error:

' Set parameters for query based on values entered
' in frmOverviewRpts form.
qdf.Parameters("Forms!frmOverviewRpts!startDate") _
= frm!startdate
qdf.Parameters("Forms!frmOverviewRpts!EndDate") _
= frm!enddate

' Open Recordset object.
Set rstReport = qdf.OpenRecordset()

Any ideas would be greatly appreciated!!!!

Fred
 
Sorry, I figured it out - I was using the NZ function in the query I was referencing - Sorry!!!!

Fred
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top