Search results for query: *

Thanks John, It works. Thanks for your help. -Randy

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

Thanks MisterC. I thought it was clear that when I imported numbers, the field data type would have been automatically set to number. I think there were some null or blank values which may have caused the data type for that column to be set to text. Thanks again

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...

Thanks mycotropic and braindead2, I used the "OR" lines of the query and was able to get it working. Sorry for the confusion there. I appreciate your help. Thanks! -Randy

The method you choose would only filter and display the list of genes that have values of > or equal to 50 in all 4 columns. It would leave out genes of interest which may only have >=50 in only one column. Still thanks for your help. If you or anyone have any other ideas, it would be greatly...

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...

Thanks Terry. I'll give it a try. -Randy

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...