M
mrwawa
Hi all,
I have an Access table with some DNA sequences in it that I want to
pull some data out of but can't do it conveniently. This is what I
have.
A table with the following 4 columns:
Sample_region (Sample name plus region (category)), Sample,region,
sequence
Sample_region is unique, sample is not because I have multiple
regions.
I want to query by sample and add all sequences that are either A or B
region and put them in one record. For example a record would be
[sample],[region A sequence],[region B sequence]. The way I am trying
to do it gives me multiple records with the same sample name. I think
that I basically want to add a search criteria for the sequence column
that selects either A or B.
Any help would be greatly appreciated.
Wade
I have an Access table with some DNA sequences in it that I want to
pull some data out of but can't do it conveniently. This is what I
have.
A table with the following 4 columns:
Sample_region (Sample name plus region (category)), Sample,region,
sequence
Sample_region is unique, sample is not because I have multiple
regions.
I want to query by sample and add all sequences that are either A or B
region and put them in one record. For example a record would be
[sample],[region A sequence],[region B sequence]. The way I am trying
to do it gives me multiple records with the same sample name. I think
that I basically want to add a search criteria for the sequence column
that selects either A or B.
Any help would be greatly appreciated.
Wade