thank you very much for both of your advice. I also found out that my tables contained a many-to-many relationships and I have decided to change it 'cos at my level, I don't think I can query it properly.
Alan,
I don't know programming and am new to Microsoft Access. In microsoft Access, I used the simple query wizard as well as entered the query in the query design view.
I have 2 tables - 1 for Individual contact details and another is Organisation contact details.
Both have fields that contain...
Hi, I'm very very new to Microsoft Access with no background in computer programming and am now learning how to use query. I have 2 tables and both contains lookup values from each tables. There are also multiple values in some of the fields.
The problem is when I use the simple query wizard...