User Profile

Collapse

Profile Sidebar

Collapse
lpape
lpape
Last Activity: Jun 12 '07, 11:19 AM
Joined: Jun 11 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • lpape
    replied to Building an expression
    in Access
    Thanks for the code, but that did not give me both amounts, it only gave me DISTR_AMT. If DISTR_AMT was null it not give me INSUR amount...
    See more | Go to post

      Leave a comment:

    • lpape
      replied to Building an expression
      in Access
      thank you as you can tell I am new to both the scripts and microsoft access. How do I know if somebody has posted to my question
      See more | Go to post

        Leave a comment:

      • lpape
        started a topic Building an expression
        in Access

        Building an expression

        I am new to Microsoft Access and I am having to make a change to code that already exists. Here is what I am trying to do:

        B_COST: IIf([DISTR_AMT]NOT NULL,"B_COST",I If([INSUR]NOT NULL,"B_COST"))

        What I am trying to accomplish is the field B_COST will consist of amounts from DISTR_AMT if it is not null or amounts from INSUR if it is not null. I tried using an OR statment but it did not like it....
        See more | Go to post
        No activity results to display
        Show More
        Working...