469,602 Members | 1,747 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,602 developers. It's quick & easy.

which is the output format of a dlookup?

5
Hi,

I've got this instruction in a column of a query:

DLookUp("[SumaDePUNTOS]","qryPuntospORPescador","APELLIDO='" & [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. The records in the field "SumaDePUNTOS" in the query "qryPuntosPorPescador" are "numbers" and I need the DLookUp function to return "numbers"

Is there anything regarding the DLookUp that I'm missing? Is there any way to convert the text into numbers by adding something like Format(DLookUp...)
I don't know how the format function works either.
Thank you very much
Mar 18 '07 #1
3 2694
MMcCarthy
14,534 Expert Mod 8TB
Hi,

I've got this instruction in a column of a query:

DLookUp("[SumaDePUNTOS]","qryPuntospORPescador","APELLIDO='" & [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. The records in the field "SumaDePUNTOS" in the query "qryPuntosPorPescador" are "numbers" and I need the DLookUp function to return "numbers"

Is there anything regarding the DLookUp that I'm missing? Is there any way to convert the text into numbers by adding something like Format(DLookUp...)
I don't know how the format function works either.
Thank you very much
Where are you storing the return? In a textbox on a form or a variable in code? In other words where is this code?
Mar 18 '07 #2
ECUweb
5
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.
Mar 21 '07 #3
MMcCarthy
14,534 Expert Mod 8TB
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.
Try this ...

Expand|Select|Wrap|Line Numbers
  1. CLng(DLookUp("[SumaDePUNTOS]","qryPuntospORPescador","APELLIDO='" & [APELLIDO] & "' AND NOMBREPESCADOR ='" & [NOMBREPESCADOR] & "'"))
Mar 21 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by Kalvin Schroder | last post: by
11 posts views Thread by Nick J | last post: by
2 posts views Thread by ctyrrell | last post: by
reply views Thread by guiromero | last post: by
reply views Thread by devrayhaan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.