Hello guys, I have a database in access 2007, but it is recorded in 2002 - 2003, I created around 5 selected to join table together, one among them, hold records but others no, I was looking where the problem might be I did not get that, the difference between those that don't hold records and the one which hold records is that which hold records has one field related to it from another table where others in each one of the selected query in they combination has more than one items from others table..
Please help know what I can do to make those select query holds their records too.
[edit]SHOUTING removed - OriginalGriff[/edit]