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) [...]

Answer Question   |  October 12, 2010  6:19 PM
DLookup, IIF, IIF function, IIF statement

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. =DLookUp(“[MyField]“,”MyTable”,”[ID]=Forms![MyForm]![ID]-1″) Any suggestions? Thank you.

Answer Question   |  February 8, 2010  9:52 AM
DLookup, Microsoft Access

dlookup
how does dlookup work?

Answer Question   |  July 6, 2009  1:43 PM
DLookup, Microsoft Access

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 on [...]

Answer Question   |  May 13, 2009  4:24 AM
DLookup, Query optimization, WHERE statement

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. Example: [...]

Answer Question   |  December 2, 2008  3:12 PM
DLookup, Microsoft Access