Query Referencing

[Midland]

I am working with the following expression in my query:

QSetUpNum: DLookUp("[DataLink]![SetupNum]","[DataLink]","[PN]")

The query name is InQry, the Datalink table is a reference for production
set up and completion rates. "PN" is a field name in InQry. I get the
impression that an aggregrate function in expression cannot refer to another
field in the same query, expect that this is not a restriction I can find
anywhere in my reference material. No matter what I put in that third
argument, I get the "cannot find the name" error message. What am I missing?

 

[Jeff Boyce]

If I'm understanding your description, you are trying to use DLookup() to
find a value in a query. Where's the name of the query in the DLookup()
expression?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Chegu Tom]

The third parameter requires a logical expression. Is PN a boolean
(logical) field? If it is text or numer you need to have +,<,>, or Like
operators

If setupNum is a field in your DataLink table then you don't need the
[DataLink]! in the first parameter

 

[Midland]

Oversimplified a bit, but, making the criteria complete, the expression
should read:

QSetUpNum:
DLookUp("[DataLink]![SetupNum]","[DataLink]","[Datalink]![RateID]=[InQry]![QRateID]")

No matter how I tweak it, it still refuses to recognize the name QRateID,
which is a field in the same query. However, I have tried a criteria from the
original data table, and random fields. The expression won't recognize
anything but a constant, which isn't of any use. I feel I am making some
elementary typing error, here, but I have no idea what it is.

--
Midland

If I'm understanding your description, you are trying to use DLookup() to
find a value in a query. Where's the name of the query in the DLookup()
expression?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I am working with the following expression in my query:

QSetUpNum: DLookUp("[DataLink]![SetupNum]","[DataLink]","[PN]")

The query name is InQry, the Datalink table is a reference for production
set up and completion rates. "PN" is a field name in InQry. I get the
impression that an aggregrate function in expression cannot refer to
another
field in the same query, expect that this is not a restriction I can find
anywhere in my reference material. No matter what I put in that third
argument, I get the "cannot find the name" error message. What am I
missing?

 

[Jeff Boyce]

I may be mis-remembering the syntax, but if you are looking for a value that
is IN the query, you need to start with that, not end with it. Have you
confimed that the syntax you are using matches what you find in Access HELP?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Oversimplified a bit, but, making the criteria complete, the expression
should read:

QSetUpNum:
DLookUp("[DataLink]![SetupNum]","[DataLink]","[Datalink]![RateID]=[InQry]![QRateID]")

No matter how I tweak it, it still refuses to recognize the name QRateID,
which is a field in the same query. However, I have tried a criteria from
the
original data table, and random fields. The expression won't recognize
anything but a constant, which isn't of any use. I feel I am making some
elementary typing error, here, but I have no idea what it is.

--
Midland

If I'm understanding your description, you are trying to use DLookup() to
find a value in a query. Where's the name of the query in the DLookup()
expression?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I am working with the following expression in my query:

QSetUpNum: DLookUp("[DataLink]![SetupNum]","[DataLink]","[PN]")

The query name is InQry, the Datalink table is a reference for
production
set up and completion rates. "PN" is a field name in InQry. I get the
impression that an aggregrate function in expression cannot refer to
another
field in the same query, expect that this is not a restriction I can
find
anywhere in my reference material. No matter what I put in that third
argument, I get the "cannot find the name" error message. What am I
missing?