troubleshooting Question

Query line counter

Avatar of Evert Jor
Evert JorFlag for Norway asked on
Microsoft AccessVBASQL
9 Comments3 Solutions81 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
Evert Jor
DVM/Researcher

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 3 Answers and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros