Hi all,
Very new to access...so, I went out and bought the Access 2002 Bible. I've created my first database that gathers 15000 records (11 columns of data) and imports it from a webpage and can prepare reports on gathered data. I've got all of my interfaces designed but I've hit a bit of a snag...I can't get a query to work for me.
The query I need will take a table list of items (around 100 items) and compare it to the large table of 15000 records. If any of the 100 items match in two of the columns in the large table..i'd like it to display those matched records (the entire row...all 11 columns) in another table or perhaps in a query. I've looked now for about 4 days in the access bible and have come to the conclusion that the solution might not be in there. Can anyone help me?
Very new to access...so, I went out and bought the Access 2002 Bible. I've created my first database that gathers 15000 records (11 columns of data) and imports it from a webpage and can prepare reports on gathered data. I've got all of my interfaces designed but I've hit a bit of a snag...I can't get a query to work for me.
The query I need will take a table list of items (around 100 items) and compare it to the large table of 15000 records. If any of the 100 items match in two of the columns in the large table..i'd like it to display those matched records (the entire row...all 11 columns) in another table or perhaps in a query. I've looked now for about 4 days in the access bible and have come to the conclusion that the solution might not be in there. Can anyone help me?