asked on Query line counter
I need to use a value that I get from DLookUp("[ID_m]";"tbl_ID_M
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
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
Microsoft AccessVBASQL
Last Comment
Evert Jor
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
How are using this query? Are you displaying this in a form, or a report?
ASKER
Ryan: Looked at your example. The problem is that there is no unique ID in the query (yourTable). That is the main issue. I need to get the value 200 into the query and add +1 for each line in the query result.
Best regards,
Evert
Best regards,
Evert
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
OK. I will try to use your suggestion and some other scripts to get this to work. I will probably need until next week (Easter Holidays).
I will post the solution once I have it.
I will post the solution once I have it.
If you're making a single pass through the recordset you can do a line counter easily.
But if you're going to use this in a form where you're going to move back-and-forth through the records that then you cannot use that technique. However depending on the situation at temp table often work.
Jim
But if you're going to use this in a form where you're going to move back-and-forth through the records that then you cannot use that technique. However depending on the situation at temp table often work.
Jim
any progress so far?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks Ryan, your solution was the best suggestion - although I ended up with a workaround due to the missing ID-field in the original dataset.