Hi, thank you for your answer. I haven't come back earlier because I solved the problem with FindFirst in VB. Anyway, I'd like to know the answer to my question. The thing is:
The code is in a query and the result appears in the column when I open the query in spreadsheet view. I also use the results to sort out the records on a report.
ECUweb
Last Activity: May 7 '07, 02:36 PM
Joined: Feb 27 '07
Location:
-
which is the output format of a dlookup?
Hi,
I've got this instruction in a column of a query:
DLookUp("[SumaDePUNTOS]","qryPuntospOR Pescador","APEL LIDO='" & [APELLIDO] & "' AND NOMBREPESCADOR ='" & [NOMBREPESCADOR] & "'")
I need to sort out the records of the column in "numerical" ascending order. However, the results of the DLookUp function are converted into text.... -
Thank you. I'll try to make it work and come back with the outcome!Leave a comment:
-
Yes, please. I'm not an expert with code but I can manage it.Leave a comment:
-
Allocating points to a sorted list of records
Hi,
I need to sort out a list of records based on the field "Weight" and then allocate points (from 1 to 10) to each record (in another field "Points") depending on the position of the record in the sorted list. Sorting out the list is not the problem for me but allocating the points is. The other problem is that when for example two records have the same weight, the allocated points should be the same, even when in the...
No activity results to display
Leave a comment: