Search results

  1. J

    IIF used in Northwind query

    I am totally lost with this usage of the IIF function. I can't figure out what is the truepart and what is the falsepart. File As: IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & ", " & [First Name]))
  2. J

    Form vs sub-Form for data integrity

    I was reading somewhere that it is not good to update two tables from a single form. Something to do with data integrity. On the other hand it seems to me that using an update query for the two tables is exactly what is required to populate the form. I'm confused...again....
  3. J

    Hold the phone! Am I delusional?

    I have not used Access in many years and even then it was not developing an application. However, as I mentioned in my introduction, I have worked with other databases for about 30 years. Anyway....I assumed that an Access application could be used by multiple users simultaneously. I thought it...
  4. J

    First Post : Introduction

    I was laid off from my engineering job last June so I decided to semi-retire. I wanted to keep working part time so I got a little project converting a company's Excel based "database" to an Access database. While doing engineering / design work, I used Dbase III/IV and another database that...
Back
Top Bottom