aajish

Sorry, here is another try! If you look at the picture i have attached you can see that the portal has fields called Fgl2 Cre LoxP I need to be able to summarize how many of those records have Fgl2 = +/- , Cre = Cre/+, LoxP = lox/+ So basically I want to write formula that would be something like {Count(IF Fgl2 = "+/-" & Cre ="cre/+" & LoxP ="lox/+")} just one another question, is it possible to merge fields in portal?

Here is the picture of the portal that i need to do calculation for. I was able to do what comment said.. now i have another issue.. i need to summarize the genotype!! ie. have a small table saying that this breeding pair has 4 pups with "+/- cre/+ lox/+" and 1 "-/- cre/+ +/+". lemme know if this is confusing.. please i really need to get this done soon : any help wud be appreciated thanks a million

sorry.. this is how my database is one file contains all the information about mice that we are working with. the information contains.. parents, date of birth, sex, colour, tag #. Now i am making another database that gets the information from this first database and puts in another database that organizes it according to the breeding pairs. I have a portal in the second database that gets the information from the first database based on the breeding pair (parents). The portal also gives information about the sex and date of birth of mice from that certain breeding pair. I need to summarize the number of females and males from each breeding pair. I used the formula given by "comment" and it works only if i have another field in the first data base. I wanted to be able to count the number of females and males using the portal and not have to make another field in the first database. i am not sure if that is clear. also i am not clear about using case function. Should i be using that in first database or second one where the portal is?

hi, thanks for ur help.. just one problem! when i try reading portal it only read whatever is in my first record. If it says "male" it counts rest of them as males and if first record is female it counts all the other records as females.

Hi, I have a field - gender. I need to count number of males and number of females in the portal!! when i do count function it only read the first one in the portal. I want to be able to say Select Gender = "Male" and Count. what do i doo??? please help!?!