Search results

  1. R

    Enter Parameter Value despite no Parameter in query

    Thanks for your help, seems as though if the column alias is to the left of where it is referenced in the query builder it doesnt pop-up with the parameter box. will confirm this after getting everything in the right order!
  2. R

    Enter Parameter Value despite no Parameter in query

    THanks for your quick response. The query designer has got it like the following: SELECT ... , IIf([Device Definition].[DeviceType]="RTU",(-Int([IO with fuses]/(-16))),(-Int([IO with fuses]/(-32)))) AS CardsWithFuses GROUP BY... , IIf([Device Definition].[DeviceType]="RTU",(-Int([IO with...
  3. R

    Enter Parameter Value despite no Parameter in query

    I think I am doing the naming correctly but the CardsWithFuses column is used in a calculation in another column in the query builder. What order does the query execute? i.e. can the value for CardsWithFuses be populated before it is used elsewhere?
  4. R

    Enter Parameter Value despite no Parameter in query

    Hello, I think I have an issue that should be able to be solved in seconds but I cant find anything online or in this forum to help me. I have a query made using the Query Designer. In Field: CardsWithFuses: IIf([Device...
Top Bottom