M marckk Registered User. Local time Today, 08:42 Joined Mar 22, 2012 Messages 18 Mar 29, 2012 #1 if I want to count the total of two values in a column that has 5 values and 80 records, what's the best way to do that?
if I want to count the total of two values in a column that has 5 values and 80 records, what's the best way to do that?
RainLover VIP From a land downunder Local time Tomorrow, 00:42 Joined Jan 5, 2009 Messages 5,031 Mar 29, 2012 #2 What is about these two values you wish to sum. Are they a different type of some sort.
M marckk Registered User. Local time Today, 08:42 Joined Mar 22, 2012 Messages 18 Mar 29, 2012 #3 ultimately i want a percentage, these two totaled and divided by the number of records.
P plog Banishment Pending Local time Today, 07:42 Joined May 11, 2011 Messages 12,055 Mar 29, 2012 #4 Could you post some sample data as well as what you want the ultimate output to be from that data?
M marckk Registered User. Local time Today, 08:42 Joined Mar 22, 2012 Messages 18 Mar 29, 2012 #5 So the total records that = (1 week + 2 weeks) / (1 week + 2 weeks + 3 weeks + I don't recall having an intake meeting + I don't recal how long it took + less than 1 week + More than 3 weeks)
So the total records that = (1 week + 2 weeks) / (1 week + 2 weeks + 3 weeks + I don't recall having an intake meeting + I don't recal how long it took + less than 1 week + More than 3 weeks)
RainLover VIP From a land downunder Local time Tomorrow, 00:42 Joined Jan 5, 2009 Messages 5,031 Mar 29, 2012 #6 Please post your Query
M marckk Registered User. Local time Today, 08:42 Joined Mar 22, 2012 Messages 18 Mar 29, 2012 #7 Query1 Criteria = "1 week" Or "2 weeks"
P plog Banishment Pending Local time Today, 07:42 Joined May 11, 2011 Messages 12,055 Mar 29, 2012 #8 Its like pulling teeth.
