Search results

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...

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...

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...

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...

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...

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...