Some records not included in table

[KeesW]

I am doing a door schedule and have a table called 'Rooms' linked to a table called 'Door Schedule'. Relationships seem fine because it works for about 90 rooms. However, it won't include about 6 rooms in the list even though these have been added in exactly the same way as all the other rooms, using the same table.

[KeesW]

They have! I've just deleted and re-added them.

[RuralGuy]

Does this mean you have resolved your issue?

[KeesW]

No. I just redid the missing records to see if this would ix it - and it hasn't.

[RuralGuy]

Could you post the SQL of the query here please?

[KeesW]

Thanks for your response. Please explain what SQL you want. I can as easily post the access file.

[RuralGuy]

Go ahead and Compact and Repair the db and then zip it up and post it. That would be the easiest.

[KeesW]

I've compacted and compressed it. What email should I send it to?

[KeesW]

I've compacted and compressed it. What email should I send it to?

I'll try this.
After opening my database please note the following:
Table 'tRooms' includes Rooms H06, H09, H10, H11, H12, H12 and H13.
Table 'tDoor Schedule' only includes Room H09.
Query 'qDoor Schedule', which combines data from tables Rooms and Door Schedule also excludes the other 'H##' designated rooms.

The 'tRooms' table was created before the 'tDoor Schedule' table and most of the rooms wer added in the same session. I've sine added some other Rooms and they have all been processed correctly. Only the majority of the 'H##' rooms are being omitted.

I've checked the links in my tables and Access tells me that these are OK.

I am quite mystified.

[RuralGuy]

Open the "qDOOR SCHEDULE 1" query in design view and then right click on the line between the two tables and look at the Join Properties. Is that what you want?

[KeesW]

Yes that is what I want. It has worked for all of the other 80 or so rooms. Why not these missing ones - that is my question! I cannot put it any clearer than this!

[RuralGuy]

There are only two "H" records in the [tDOOR SCHEDULE] table and they are both "H09" records. Since you are using an INNER JOIN that "only shows records where the joined fields from both tables are equal", the most you can have returned in the query is two "H09" records.

How do you "add rooms" to the door schedule?

[KeesW]

Thanks for that. I'll check it. It doesn't explain why the other 123 doors entered at the same time, using the same 'joins' and relationships worked correctly.
I add 'rooms' using the 'tROOMS' table. Because of the relationships and joins that I've set up, they automatically flow through to the 'tDOOR SCHEDULE' table.

I've just tried changing the 'joins' and it hasn't worked.

[RuralGuy]

I don't understand how you use the tROOMS table to add records to the tDOOR SCHEDULE table. Access has nothing to cause that to happen at the Table level. Don't you use a Form for such an operation?