MS Access Math problem?
477479
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));
636777
=(cell number+cell number) \nYou just have to click on the cell that has what you want added, subtracted or multiplied. Simple, really. And you can use more cells than that. Have fun.\nAnother formula might be \n=A(cell number+cell number)
992198
To sum a column, use:\nselect sum(the_column) from the_table
66748
Well this is easy, what you have to do is put in the values as follows:\n\nA1 = 10000\nA2 = =(A1*0.25)+A1\nA3 to A5 jus drag the column in A2, this will compute the percentage of each column just above the column with the formula, and give the result you want.\n\nI hope this is the solution u were looking at.\n\nRegards\nChris
187676
Your best bet would probably be a list of checkboxes to match each question.\n\nOnce all the checkboxes have been filled in then submit the form and all the information gets transfered to a database.\n\nDo this as a standalone webpage with a DB backend. Probably something like mySQL or SQL2k, SQL2003 would be your best bet as Access only supports 10 connections at a time and you may overload this if you have multiple people entering data at the same time.
948763
access can import many types of files,  it looks for a hard carraige return to seperate each records out.  You can seperate the fields with comma's.  Then import them into access.  This might not be an easier solution, please let me know if you have any questions. \n\nHope this helps.
946717
I think the simplest way to solve this is to move the decimal place over one to the left.   If for example they wanted 1% you would move it over two to the left.  If they wanted .01% three to the left.  If they wanted .001% four to the left.  You get the point. \n\nSo 10%= $2500
637825
MS Access environment\n\nYou must create a field in Table Teachers that uniquely identifies each teacher. It can be an Autonumber field.\nGiven this, each time you add a teacher, the software will give this record a unique number.\n\nIn Students Table, create a field with number Long Integer data type.\n\nGo to Tools>Relationships and set a one-to-many relationship between the 2 tables using these 2 fields.\n\nCreate a query with this 2 tables using the fields in table Students and only the fields in table Teachers you want to show (not the autonumber field)\n\nMakiavel
1182532
Ok, if I am understanding this properly, access is referring to Microsoft Access?\n\nYou cannot open a dbf file from within Access.
351083
In A3, put "=SUM(A1:A2)" or just "=A1+A2"
254134
I believe Access SQL supports the TOP keyword as below.  This will allow you to easily limit the number of records.\n\nSelect TOP field1, field2, field3\nfrom mytable1 m1 left join mytable2 m2\n on m1.field1 = m2.field4\nwhere field1 = 'value'
550918
Type "=B1-C1+D1*A1" without the quotes inside another cell such as E1.  This is assuming that your equation is the correct algebraic form and solved for one variable.  Your text is a bit jumbled so I didn't parse all of it.
831601
Create a table. Fill in each number you want to add in the same column, but different rows. Leave one column empty at the end. Go to the Toolbar and click on Table. Then click on formulas. In the Formula box you add your formula:\n=SUM(above).\n\nCreate a table. Fill in each number you want to add in the same row, but different column Leave one column empty at the the far right. Go to the Toolbar and click on Table. Then click on formulas. In the Formula box you add your formula:\n=SUM(left).\n\nFor autotext features:\nAuto Correct Tab:  Fill in a word you want to replace in the box and then type the word you want to replace it with. I do this for words I tend to misspell. (I.e., wierd with weird)\nOn the auto text text you can fill in a phrase that you would like completed so you don't have to type it in. You could use your name. John A Doe. When you type John the rest of the name will appear and all you have to do is hit enter and the name is completed.
830543
{=SUM(IF($A$2:$A$11 = DATEVALUE("11/29/06"), $B$2:$B$11, 0))}\n\nThis example (an array formula, so hit CTRL+Shift+Enter when you finish typing it instead of just Enter (don't type the brackets - { } )) sums the contents of Column B  for every instance the Column A contains 11-29). Just modify it to match your cell references and it should work just fine.
238613
How many items? If it's over 1000, you better go with access, or get frustrated trying to use excel (unless your needs are very simple). I think excel has a limit of about 65535 rows, but if your tracking that many, you definitely want to use a database such as MS Access.
864721
I assume you mean in MS Excel????????\n\nPutting a '$' in front of the reference will force the reference to look at exactly that place and not at a relative location.\n\ne.g. $A23 will mean that every cell looks at column 'A' regardless of whether column A is 5 or 55 columns away, but the row reference will be relative to the row in use.\n$A$23 will force the reference to point to exactly that cell.\n\n///
126717
Access has limits in it's database it's not ment to be a bussiness database thats what sql is for...\nhttp://databases.about.com/cs/tutorials/a/widgetmenu.htm