GeorgeBramhall2
2 years agoQrew Cadet
GetFieldValues Query Question
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
------------------------------
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
------------------------------