Please can someone point me to detailed instructions on the use of queries, or resolve the following problem. I have read the Getting Started documentation and have no problem with it but it does not answer my problem.
I have two large tables in a database converted from Access, A and B. Table A contains 3 fields 2 of which I am interested in , namely ID, y and z. Similarly table B also has 3 fields ID, w and x. In Table A field z I can insert a number which gives me a list of all instances for the equivalent field in field y. This field then becomes field w in table B and I wish to know all instances in field x that the output in field y (=field w) occur. Please note that the fields y and w do not have the same title. I hope this is clear, Thank you. Ron Ferguson
