• DLookup or IIF statement?

    How do I update the value of one row with the value of a different row? i want to build an expression For example: I have 3 columns. If Column 1=C and C is Null, then I want the values for C in Column 2 to = 10000 (the value from Column 2 for A) and the values for C in Column 3 to = 22000 9the...

    Alexvalentina10 pointsBadges:
  • Getting DLookup to refer to a previous record in a filter

    I am trying to use DlookUp to get field values from a previous recrod wher the records have been filtered.   I have found the code below but it refers to ID-1, rather the actual ID that may be the previous record resulting from the filter....

    TRSJ45 pointsBadges:
  • dlookup

    how does dlookup work?

    Davva10 pointsBadges:
  • Calculating prior Query fields

    Inside my query, is four listed fields; date, printer, and a Start and End meter for daily meter readings to keep track of printer impressions. I'm trying to receive a return value by subtracting a meter reading from the START field in a current row and the END meter in the previous row depending...

    Bostic8720 pointsBadges:
  • Using Dlookup to populate form fields

    I have a simple database with one table(Issue log). What I want is a form that allows for creating a new "issue" within the table or updating the status of an existing issue. I want the form (Issue log) that will update an issues' status to auto-populate based on which issue number you enter....

    Dave4015 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.