Search results

Thanks GinaWhipp will do when i get back to office Thank you so very much,

Hi Ginawipp, Not really the top 100 by date but the last 100 records entered rather than having to enter from date to date. If i am explaining myself correctly. Sorry if i am vague.

Hello, I seem to be banging my head of the wall with this one but I am looking for a way to either display through a query with an expression or any other alternative that someone may have to display the last 100 records entered maybe based on date entered or something. At the moment i have a...

I have used the Nz Function as follows but it still isnt working still not giving me the result of 0 =Nz(Sum(IIf(([Handling]>#00:02:00# And [Going]="YES"),1))) Have i used it incorrectly?

After hours of playing around i finally have my IIF statement working the proplem is now is that when the Value is null it gives a blank value on my Report. How do i get it to show the value of 0 when it is Null. can i use an isNull withen my IIf statement maybe nested what is best practice...

Thank you so very much i have learnt a new way of doing an IIF as well as getting this query working thank you again Trish:D

Hi Paul Well i have tried as you suggested as follows IIf([Mobilised]="No",Nz([Call Handling],""),Nz([(E) Call Taking],[Call Handling])) But this is returning a weird values for example 6.36574070085771E-04 even though I have put the format to long time, can you tell me what Nz stands for...

pr2-eugin, if Mobilised = No and Call handling is Null i just want an empty return if that is possible.:confused:

pr2-eugin, if Mobilised = No and Call handling is Null i just want an empty return if that is possible.

Well i have tried IIf(IsNull([(E) Call Taking]), [Call Handling], [(E) Call Taking]) And IIf([Mobilised]= "NO", [Call Handling], [(E) Call Taking]) and it is returning a value of 00:00:00 i have also put in where Mobilised ="no" takes precedence and that is not working for me either and Plog i...

Well at least i think that is what i am trying to achieve my initial IIF statement is working fine ans i have put it in bold down below but i am looking for a way to implement another condition as if i was using an "Else If " or something that will look to another row and if mobilised = "NO" i...

Thanks jdraw for the fast reply and i see know where the date create and date modified can be put into the query. Is it possible to also add the description (if any) associated with each query to the outcome of the query and is there any other way that i can get a list of queries with the...

Hi there, I am hoping to do a report all my queries in my Database. I have managed to use some sql code to list the queries which is the following: SELECT MSYSOBJECTS.Name FROM MSYSOBJECTS WHERE (((MSYSOBJECTS.Type)=5) AND ((Left([NAME],1))<>"~")); But i cant seem to get any further i would...

HI John Big Booty I dont want it showing in the query result as it is used by other users and i just want it for a report result, i have a report that is linked to this query where i have an expression reading from the query result, if you know what i mean i just want it if you like running in...

I have created an IIf statement that i dont want to show up in the query result, so i have unticked the "show" option as again i dont want it showing up on the result once the query is ran. But every time i untick it then save the query the expression is being deleted automatically, but when i...

The Nz() function Worked a treat, thanks guys for the help

HI lagbolt, Thanks for the welcome, Well i have used that statement as you suggested and i have removed brackets and inserted them and i still seem to be getting the same error "The expression you entered has a function containing the wrong number of arguements" :banghead: any suggestions as...

I was hoping someone would be able to help me, i want to create an sql expression or even use the expression builder that will if Column A has a Null Value replace with the data from another Column-B i have tried to use the if statement as below IIf(Column_A=null (Column_B),(Column_A)) but this...