I have 3 variables that I know. I need to find out the missed % for each line by using the 100% format.  I need it for a query.\n\n\n\n\nSession--Total Missed------# Days Active\n42-------29----------------51\n86-------0-----------------59\n35-------4-----------------118\n16-------5-----------------444
216847
I'm not sure which of the two variables is relevant here so I'll assume that you want to know [Total Missed] as a percentage of Session.\n\nCreate a MS query using the table that includes your data. In one of the columns, instead of dragging one of the fields from the table, enter the formula ([Total Missed]/Session). You need the brackets because "Total Missed" contains a space. Be sure to add a condition so you aren't dividing by 0.\n\nAccess will name the column Expr1:([Total Missed]/Session)\n\nIf you look at the query using the SQL view, it will look something like this:\n\nSELECT ([Total Missed]/Session) AS Expr1\nFROM [Table Name]\nWHERE ((([Table Name].Session)>0));
489133
take 35-3, which is 32.  then divide 32 by 35.  you'll get a decimal answer,  move the decimal to the right 2 spaces and that's your percent
384560
10.7%\n\n(1030 - 920) / 1030 = 0.107
318991
well first, you need the actual value, then use the %error formula\n\n(actual-experimental) / actual X 100% = (just change the sign if it is negative)\n\nyou should probably use the averages of the 2 methods you used, but without the actual value, i can't get you the answer
376505
Use this in D1\n=IF( OR( C1=101, C1=104, C1=105, C1=276, C1=632, C1=635), 1, "Empty")\nThis will check if C1 equals one of the values you entered here to show 1, and show "Empty" if it is not.\nThe C1=XXX section as you see is repeated inside the OR function.\nYou can put up to 30 conditions here, means OR accepts up to 30 times C1=XXX\nIf you have more than 30 conditions, or need more info, mail me here\n\n\nEnjoy my profile, I am the VBAXLMan
428939
Create an outer for loop that will loop from 7 down to 0, with a step of 2.\n\nCreate one inner loops.\n\nThe inner loop should take the value of i, place it in another variable and count down to 0.\nThen print out the dollar signs for each iteration of this loop.
602381
This is how I would do it.\n\n 12......19\n-----  =  -----  ignore the periods in between 12/19 and 100/x\n100.....x\n\n12x = (19) (100)\n12x = 1900\n12x / 12_= 1900 / 12\nx =158.3\n\n158.3 - 100 = 58.3% increase
213932
aren't u missing a number there on the last row???\n\nin that case... i would say...\n\n9 11 13 15 17 19....
486277
while (<>)\n{\n  ($n++, $uniq{$_}++, print("$_&#92;n")) foreach /&#92;+d-&#92;d+)/g;\n}\nprint STDERR "Total numbers: $n&#92;n";\nprint STDERR "Unique numbers: scalar(%uniq)&#92;n";\nprint STDERR "Individual number counts:&#92;n";\nprint STDERR "$number: $coutn&#92;n" while ($number, $count) = each %uniq;\n\nIt reads the original text from stdin, and prints the numbers to stdout, and the statitstics to stderr.\nrun it like this:\ncat original_file.txt | perl thisprogram.pl > number_only.txt\n\nThe numbers will end up in numbers_only.txt, and the statistics will show up on your screen.\nYou can also give it the original file as argument instead of that cat thing if you prefer
359604
.8 and %80\n1/8\n3/51 and 4/51\n61 and 93\n19/247 and 1/20
205401
Create a query and paste this into it's SQL sheet:\n\nSELECT tblData.TICKER, tblData.DATE, tblData.CLOSE, (SELECT Sum([CLOSE])/Count([ticker]) AS Expr1 FROM tblData AS sub WHERE \n(((sub.TICKER)=[tblData]![Ticker]) AND ((sub.DATE) Between [tbldata]![date]-19 And [tbldata]![date]));) AS avg20 FROM tblData;\n\nIt will show the 20-day average for each stock for each date, but if there are fewer days of data available for a stock, it will show a real average for those days.\n\nI don't know what's causing the "..." in the middle of the SQL, but just replace it with "er]) "\n\nThis is what's called a Subquery
419292
Going from percent to fraction is easy.  Percent literally means "per 100" so just divide your percent by 100 to get a fraction.  For example, 16% = 16/100.  You can then simplify if you want, to get 16/100= 4/25.\n\n~ ~ ~ ~ \n\n66 2/3% = 0.66666.... or 0.6 (with a dash on top of the 6).  The fraction is 2/3.\n\nTo go from a repeating decimal to a fraction, it's a little tricky. Here's how you do it:  Notice how many numbers are in the repeating pattern -- in this case it's only the 6, so we have 1 repeating number.  Use this "1" to tell you that you need to multiply your decimal by 10^1 to solve.  (If our repeating decimal was 0.181818... that would be two repeating numbers and we'd need to use 10^2 to solve.)  Anyhoo, we have 1 repeating number, so take your decimal, call it x and take 10^1 times x minus x to solve:\n\n10x - x = 6.666... - 0.6666\n9x = 6\nx = 6/9 = 2/3\n\nAnd that's how you go from repeating decimals to a fraction!\n\n~ ~ ~ ~ \n\n18/15 = 120% = 1.20\n\n~ ♥ ~
647317
20% of 1140 is 228 hours.  (1140 * 0.20 = 228)\n\nIf you missed 87 hours, then you have missed approximately 87 / 1140 = 7.6% of your scheduled work.  Not 20%, but not insignificant.  It means you show up 92.4% of the time.\n\nThat comes to about 8 * 0.924 = 7.392 hours per day.\n\nFor your sake I hope you get paid salary and not hourly. :)
404615
173.88235294117647058823529411...%                                               (can be rounded to 173.88% or 179%)\n\nI think this is the answer.  My scratch paper sure agrees :)\n\nfor math help online go to math.com ,mathonline.org or study buddy.com\n\nTo get the answer follow me: \n739 / 425 =  1.7388235294117647058823529411\n\n1.7388235294117647058823529411 x 100 = 173.88.......\n\nTherefore, the answer is 173.88...
61796
% Yeild = .3333*100 = 33.33
504484
CREATE TABLE cus_tmp as (SELECT * FROM members WHERE tel_hp LIKE '% - %');\n\nAll you are missing is the ().\n\nEnjoy -
401875
If you are in VBA in MS Access? Than you can cut the string and used the variable directly and then finish the string.\n\nstudTbl.Open "SELECT * FROM [studlst] where ([no]=" & i &")"