fishface616
Last Activity: Feb 6 '13, 09:58 AM
Joined: Feb 1 '13
Location:
-
Sorted... it was the way i had linked the Tables, once i removed the not required and checked the Joins it worked :-) Thanks for all the help !!! -
Gents, thanks for your responses, I still get a blank row, however if enable Totals and use the drop down box I get the option to put a zero in, but it never stays there. so when I run the query it go back to being blank... Almost hair pulling out time !!Leave a comment:
-
It is a holiday/weekend VB script.. It is used later on when I combine two queries which is part of the reason I need to show zero if nothing found... Please ignore it if possible.. thanksLeave a comment:
-
Hi, thanks for quick response, attached is the SQL (Mod - Removed attachment and included the code properly in the post). the reference to ISO Workday in it is another query regarding dates. Thanks in advance as I have spent days on this. :-(
...Code:SELECT IIf([Actual_Days]<31,"OnTime","OOPS") AS Result , SA_INC_SERIOUS.INC_SERIOUS_SC , SA_ITEM.ITEM_SC , SA_INCIDENT.DATE_LOGGEDLeave a comment:
-
Require 0 if none found via query
Hi, I have a table ACT_TYPE_SC that I am trying to query, it has many possibilities but I want to check for certain criteria ie the word "Delay" and if none are found return a zero as this is used later on. I have tried Nz, Isnull but can get no joy only a blank space, please help the complete novice !! thanks
Attempts;
orCode:Field:Nz([SA_ACT_TYPE.ACT_TYPE_SC],"0")
...Code:Field:Count(*(Nz([SA_ACT_TYPE.ACT
No activity results to display
Leave a comment: