Rooming List by Queries

[Erictsang]

Dear Guru

I encounter a question in Queries

here is the file in Dropbox : https://www.dropbox.com/s/jp5micxktb...ing.accdb?dl=0

Paring field should the no of room in order and the decimal represent shared-room mate

For example, 1.1 , the person is shared with 1

Now, a search form with subform

if i type 2 in the ID field and it queries the person as well as the paring room mate

In this case, in the databased , it should show

https://www.dropbox.com/s/jp5micxktb...ing.accdb?dl=0









how can i do it Thanks in advance

Eric

[orange]

Is there a reason you have created a new post?
This seems to be a continuation of
https://www.accessforums.net/showthread.php?t=67261

[Erictsang]

Orange

As i still looking for answer