Invalid Syntax?

  • Thread starter Thread starter SokkiHong
  • Start date Start date
S

SokkiHong

Can someone please tell me what's wrong with my syntax
here?

=DLookUp("[Status]","[Issues_SubTable Query]") WHERE
(("[Issue ID]","[Issues Master Table Query]") =
("[ID]","[Issues_SubTable Query]"))

I am trying to Pull [Status] from the [Issues_SubTable
Query] only when the [ID] field of [Issues_Subtable Query]
matches up with [Issue ID] with the [Issues Master Table
Query]. Please help, thanks.
 
Where are you getting the value IssueID field from? Is it in the report's
Record Source? Is it text or numeric? DLookup() only takes a single
query/table in the domain.
 
Back
Top