Adding where to formula in a query

[bb_]

i'm trying to concatenate with allen brownes concatrelated function. i need the description for each ID where the type is internet. here's what i'm using now buts its concatenating all descriptions


Description: ConcatRelated("[Description]","[Bill Details]","Type=""" & [Type] & """" And "[ID]=" & [ID])



I want to concatenation the description where the Type field = "internet"

how can i add a where to the formula?

[pbaldy]

For just that code:

Description: ConcatRelated("[Description]","[Bill Details]","Type= 'internet' And [ID]=" & [ID])

[bb_]

thanks pbaldy- can you help me with the quotations the ID is a short text

[pbaldy]

Description: ConcatRelated("[Description]","[Bill Details]","Type= 'internet' And [ID]='" & [ID] & "'")