Search results

  1. A

    IIF in Complex query

    The client would get a new database. The client code (vb6 app.) would not change.
  2. A

    IIF in Complex query

    I think I understand what you are suggesting, but I don't know how to implement it. I don't know how to get the 1st record from othertable and return othertable!somefield in my query without making a join which is not what I want. Could I ask you to help with the syntax to update my original...
  3. A

    IIF in Complex query

    Thanks for the response. I didn't want to supply an argument to the query for the reason that it would mean updating the client application to pass the argument. Is there not a way to read the record in somefield from a table within the query itself rather than passing it as a param? Thanks.
  4. A

    IIF in Complex query

    I have the following quite long access query. It works fine but I want to be able to substitute [ItemDetails]![US_Cost] with either [ItemDetails]![US_Cost] OR [ItemDetails]![NEW_US_Cost] depending on whether [MyOtherTable]![SomeField] = 0 or 1 where this is the 1st record in the table...
Back
Top Bottom