Prob to filter record for Field1 and Field2 with same RefNo as Field1.

[awinnn]

Hi,
I have Code, RefNo and Amount. Code has value (HS, HOSPSP, HOSPIR, HOSPCH). I've set the criteria on Code like this,
In("HS","HOSPIR").

My problem is to display record for HS and HOSPIR(only with the same RefNo with HS). It is because..there are some HOSPIR with the same RefNo as HOSPSP and HOSPCH. Is it possible?

thanx in advance..

 

[MarkWright]

Hello awinnn,
I would try a query if there is more than one record given. Another way is a Dlookup. but this is useally for looking for 1 record.
Just a thought
Mark

 

[lynchg]

If I understand you correctly you might try this:

Select Code, RefNo, Amount
From TableX
Where Code In ("HS","HOSPIR") And RefNo In
(Select RefNo From TableX Where Code = "HS")

Good Luck