Query Problem

[AccessNewBoy]

Hi all,
Thanks for taking the time to look at this problem of mine and any help you can give i would be very helpfull.

I have a Query that counts how meny entries there are with set criteria's but when there are none it returns a blank display. How would i be able to make it return 0 when there are no entries and when there are entries for the query to show the figure there is?

 

[wazz]

hello.

have a look at the Nulls (Nz) function. if you can post the query we could be more specific. the nulls function can return a value if one is "not available".

 

[tara]

hi i have a problem the question says :

"add to this extract a new field called Days which is calculated at run time. this must calculate the number of whole days of each of these holidays."

there are two rows one with return date and the other with out date... how should i calculate the number of whole days for each of these holidays..??

 

[AccessNewBoy]

Hi Wazz & Tara,
Thanks for taking the time to look at my problem, so sorry for late reply as i have had a long week end away.

What i have ended up doing is using a "If Not" function where it looks at a text box (QuantityLeft1) which takes its value from a Subform and depending on its value puts either a 0 in a second textbox (QuantityLeft2) if the value is not Numeric or if the value is Numeric it displays the original value of (QuantityLeft1).

If Not (IsNumeric(QuantityLeft1)) Then
QuantityLeft2 = 0
Else
QuantityLeft2 = QuantityLeft1
End If

I underdtand some people might think or say this is bad Access design or even a long way of getting what i want but it does the job.

Once again thanks for your assistance.