I need to use a value that I get from DLookUp("[ID_m]";"tbl_ID_MAKS_VARELNORDRE";"[ID_m]") (there is only ever one record in the table) and add +1 for each line in a query result. I have tried for a few hours now, so any help appreciated. Thanks in advance.
The original query result may look like this:
Sample1 Result 234,4
Sample 15 Result 114,3
Sample 27 Result 43,2
I need the query to return, assuming the DLookup value is 200:
201 Sample1 Result 234,4
202 Sample 15 Result 114,3
203 Sample27 Result 43,2
Best regards,
Evert