Search results for query: *

Hi All, I have two tables. Table 1 contains a list of 200 genes and table 2 contains a list of 23200 genes including the 200 genes from Table 1. The 200 genes are all over the place in the list of 23200 genes in Table 2. I would like to build a query that displays all of table 2 without...

Hi all, Does anyone know how to find the standard deviation for numbers in multiple columns? Column 1 2 3 4 5 STDEV 23 12 90 01 93 44.246 I've tried using STDEV but I have errors in implementing it. Thanks, Randy Wei

Hi all, Microsoft Access is automatically adding quote marks in my criteria section of my query. I am searching for >=50. A few columns have >=50 and in some other columns Access corrects my expression to be >="50" I've tried building a new query, loading a new table, and...

Hi all, I am working on a bioinformatics database and need help in creating a filter. There are 23000 genes with 4 columns with numerical values. I would like to keep the genes that have a value >50 in at least one of the columns. If the gene has two columns with value >50 then the gene is...

Hi all, I am working on a rice and barley bioinformatics project using ACCESS at UC Berkeley. I've run into some trouble when building a query to find duplicate names in two tables. The Duplicate Query Wizard built into Access can only look for duplicates in the same table. Does anyone...