Skip to main content
Question

GetFieldValues Query Question

  • February 5, 2023
  • 0 replies
  • 107 views
GeorgeBramhall2
Forum|alt.badge.img+11
GetFieldValues(GetRecords("{17.EX.'" & [Consignee - Related Consumer] & "'}and{7.EX.'" & [Load # - Description] & "'}",[_DBID_PRICE_HISTORY]),19)

Can anyone tell me what is wrong with this query, I am not getting any results and I know that there are some.

In addition when if I query for either of the 2 filters individually I do get results, eg:
GetFieldValues(GetRecords("{17.EX.'" & [Consignee - Related Consumer] & "'}",[_DBID_PRICE_HISTORY]),19)

------------------------------
George Bramhall
------------------------------
This topic has been closed for replies.

MarceloBenavide
Forum|alt.badge.img+8
I have a question. Do you have records where the two fields match? because you use an AND statement. 

 Consulting them separately is not a good test. 

 A=XYZ and B=FGH , do you have record with the two conditions ?

Marcelo Benavides Torres 


GeorgeBramhall2
Forum|alt.badge.img+11
Thank you all for your help ... using AND vs and and going with the variable approach gave results.

------------------------------
George Bramhall
------------------------------
    Terms & ConditionsAccessibility statement