Concatenation query not sure how to add the second criteria

[Mick99]

Hi, i have a query that returns results for the code in black, however i need to filter the data by a second criteria, which is in the red. I'm no expert at how these should be joined but essentially I am still looking at the tbl_Actions to find the field ACTIONS_KEY_ID and then filter that against the current loaded MSD_SYSTEM_KEY_ID. Any help would be appreciated.

ActionsConcateObligations: ConcatRelated("Actions_ID ","tbl_Actions"," ACTIONS_WP_LINK = " & [MDS_tbl_Item_ID] & ","tbl_Actions"," ACTIONS_KEY_ID = MSD_SYSTEM_KEY_ID)

Cheers Mick

[pbaldy]

More like:

ConcatRelated("Actions_ID ","tbl_Actions"," ACTIONS_WP_LINK = " & [MDS_tbl_Item_ID] & " And ACTIONS_KEY_ID = " & MSD_SYSTEM_KEY_ID)

[June7]

ActionsConcateObligations: ConcatRelated("Actions_ID", "tbl_Actions", "ACTIONS_WP_LINK = " & [MDS_tbl_Item_ID] & " AND ACTIONS_KEY_ID = " & [MSD_SYSTEM_KEY_ID])

Are both fields number type?

If the query requires a GROUP BY, be sure to include both fields.

[Mick99]

Problem solved! Thank you very much for the help it's greatly appreciated.

Cheers Mick

[Mick99]

Thanks June7, yep both number and all group by. Solution works, i love this forum!