Multiple Table Query

[jj72uk]

OK, I won't profess to be an expert at access, I'm not in any way whatsoever. So I could really do with some help and direction!

I have been given a access db which contains 2 tables, both tables have inforamtion/data in which I need to use, the only 1 thing common in both is that the ref. column is the same, though one table will only have the reference once, whereas the 2nd table could have repeated references, which is fine.

What I would like is to run a query to display a table based on matching ref. coloum.

Ive tried using the wizard without much luck!

Can anyone talk me through how to do it?

Cheers

 

[MSAccessRookie]

Try using the Wizard again. When it asks you for tables, choose the Table with one entry per Ref Column first, and the Table with Multiple entries per Ref Column second. Then, if you drag and drop FROM one TO many, the connection should be correct

 

[jj72uk]

Thanks, it seems to be working, I think my problem now is when i export it to excel i loose some of the data, I'm guessing its because excel only have a limited amount of rows.

Is there a way to further the query, maybe use an addtional reference from a different coloum in the first sheet. eg. there's a sperate coloum showing different regions of the country so can i customise the query to only display the data which match the region specified?

 

[MSAccessRookie]

Thanks, it seems to be working, I think my problem now is when i export it to excel i loose some of the data, I'm guessing its because excel only have a limited amount of rows.

Is there a way to further the query, maybe use an addtional reference from a different coloum in the first sheet. eg. there's a sperate coloum showing different regions of the country so can i customise the query to only display the data which match the region specified?

I am not exactly sure what you mean, but it sounds like you may need a review of your table designs. If you can post the design of your tables (no data necessary), we will probably be able to make a more accurate assessment.

 

[jj72uk]

I think I've worked it out...!!

I went into design view and under criteria specified a regional name, and it seems to have worked....much less thant he 250,000 results i got before, which is why excel couldnt handle that many...