How to use Dlookup in design view of query

[Nanuaraq]

The Access web's tutorial on dlookup inly provides advice on the VBA how-to. I can only use design view, so how would I create a dlookup in design view?
I keep getting syntax errors.

Alternatively, would someone be kind as to provie an example of such a query in SQL, then I could remake that and work from there?

[June7]

You could provide sample of data and desired result.

Why do you need DLookup? Why not join tables?

Type DLookup() function in a field cell of query design view.

Duplicate https://www.accessforums.net/showthread.php?t=77697

[Nanuaraq]

It is duplicate because the other thread ran a bit wild with possible solutions, while in this case I specifically want to try out DLookup and see if it does what I need it to.

From where I'm standing, I can't make even the simplest DLookup work. I simply do not know how to properly phrase it.

For a test, I try this:

I have a table, Table1.
There is a column, Column1.
In column1, row 1, there is a field with text "hello world".

I have a query, Query1.
In query1, I want to have DLookup return "Hello world".

I am using design view. What should I enter into the generator?

Thank you in advance.


To put up an example, I try writing this in the generator in design view:

Expr1: DLookUp([Column1];[Table1];[Id]=1)

Under Expr1, I expect to see the content of Column1 in Table1 where the corresponding Id is 1 (namely the first row, where the words "Hello world" are).
When I run the query, I am asked for a parameter value, then the resulting query tells me there is an error.

[Nanuaraq]

It is duplicate because the other thread ran a bit wild with possible solutions, while in this case I specifically want to try out DLookup and see if it does what I need it to.

From where I'm standing, I can't make even the simplest DLookup work. I simply do not know how to properly phrase it.

For a test, I try this:

I have a table, Table1.
There is a column, Column1.
In column1, row 1, there is a field with text "hello world".

I have a query, Query1.
In query1, I want to have DLookup return "Hello world".

I am using design view. What should I enter into the generator?

Thank you in advance.


To put up an example, I try writing this in the generator in design view:

Expr1: DLookUp([Column1];[Table1];[Id]=1)

Under Expr1, I expect to see the content of Column1 in Table1 where the corresponding Id is 1 (namely the first row, where the words "Hello world" are).
When I run the query, I am asked for a parameter value, then the resulting query tells me there is an error.

Nevermind, Youtube did it:
https://www.youtube.com/watch?v=hUsHKvhKDh0

And heres the expression that saved it:
Expr1: DLookUp("Column1";"Table1";"[Id]=1")

Just like that. Well, better get cracking, I need to see how this works in the project.