Can someone please tell me what I'm doing wrong on this? I think it's one of those days... I have a distinct list . that contains a list of words found in .....

I need help.. When I add the Nz to the below cell in my query it changes it from currency to text. What can I do to resolve this issue. I am adding Nz because...

How can effectivly use NZ for the following two expressions? If I live some record without a date in, I am getting error messages. CalenDays:...

Hello: About a year ago I got help from this board in using NZ to retreive a zero instead of a null value. I'm having trouble remembering how to use...

I have a simple count query that I would like to put a zero for a null value for the count and also indicate the group that was counted. following is the...

Good Morning! I have the following expression built: OHPerc: NZ(,0)/NZ(,0) In the properties I have it formatted to show ##% My problem is sometimes the...

The Nz function used in the following query SQL statement returns nothing, not even a blank box. I need it to return a 0. Thanks for all your help. SELECT...

I have a query where I would like for all employee records to display for time taken. If the employee has not taken any time off, the record should show...

Hi All, the query below shows an error if any of the date in / date out entries in the table are empty. How can i impiment the Nz function to stop this. SQL...

Folks, I've got a query that's something like : SELECT Nz(Materials.MaterialCost, 0) FROM Materials This works fine in Access but when I call from my .NET...

I am creating a simple query. The table is InsuranceExpense. The field is InsAmt. There is nothing in the table yet. I put TtlInsurance: Sum(CCur(Nz(,0)))...

I have a query like this: Name: Nz(;) and in SQLwindow: INSERT INTO Mytable ( ID, Name) SELECT Diptera.ID, Nz(, ) AS Name FROM Diptera; The table Mytable...

My query looks like this: SELECT Diptera.ID, NZ(,) AS Name INTO FROM Diptera; I get a compile error. What sould I do? DAO 3.6 Object Library is ok. The query...

Hi, I have 2 tables - a main table (tbl_Opportunity) and a look-up table (tbl_AMContacts). I have a field in each (AllianceMgr) that links the two tables...

hello all, I am currently using the Nz function to populate the null values with zeros so that I can build calculated fields in queries. The NZ function...

I am using the Nz Function it work fine but my Currency is now gone how can i get the currency format to return? SELECT qrySubCost.Division,...

I not sure how to use the NZ functions for my calulations. I have a query that counts the number of records for a certain period of time. For some periods...

Hi I have an expression in my query that combines a number of fields for Coordinators. In most instances the coordinator contact details that get returned...

Hello, I have a query to get inventory item sold total in a period. i.e. total 5 items from item1 to item5 from 1/1/2004 to 12/31/2004 sold following...

I am trying to use an nz function on a query, so that I get a zero instead of a blank. I can't figure out where to actually type the nz function. Do I type...