User Profile

Collapse

Profile Sidebar

Collapse
Mark1978
Mark1978
Last Activity: Nov 5 '07, 10:01 AM
Joined: Jun 14 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Mark1978
    replied to Using Dlookup to generate an IIf statement
    in Access
    Good idea it did not occur to me to try that, unfortunately I get the message;

    "The expression is typed incorrectly, or is too complex to be evaluated....."

    I know its not the former so I am obviously trying to evaluate too much.

    Thanks for the advice though.
    See more | Go to post

      Leave a comment:

    • Mark1978
      started a topic Using Dlookup to generate an IIf statement
      in Access

      Using Dlookup to generate an IIf statement

      Hi All

      Apologies if someone has asked this question before, but I have hunted high and low for the solution.

      I am relatively new to using access so am not sure if this is possible. I am using MS Access 2003.

      I want to use the result of one query as an IIf statement in a calculated field in a new query.

      I have tried using dlookup to do this but the result is just the IIf statement posted...
      See more | Go to post
      No activity results to display
      Show More
      Working...