where clause help

  • Thread starter Thread starter Lee-Anne Waters via AccessMonster.com
  • Start date Start date
L

Lee-Anne Waters via AccessMonster.com

Hi,

i'm trying to concatenate a set of data into one cell where it meets set
critera.

what i have thus far is

Attributes: Concatenate("SELECT NCJoin FROM qryNCItem_Join WHERE
TrackingNumber =" & [TrackingNumber]) & ("SELECT NCJoin FROM qryNCItem_Join
WHERE ActivityCode =" & [ActivityCode])

i just can not seem to get it right where it meets two sets of criterea,

hopefully its just my syntax
thanks
Lee-Anne
 
Lee-Anne,

Maybe you need it like this...

Attributes: Concatenate("SELECT NCJoin FROM qryNCItem_Join WHERE
TrackingNumber=" & [TrackingNumber] & " And ActivityCode=" & [ActivityCode])

This assumes TrackingNumber and ActivityCode are both numerical... is
that correct?
 
Back
Top