how can I find a moving average using in Access?
455478
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
436027
The usual way to do this is to have 2 tables.  One table for your purchases (i.e. the items you are bringing into your inventory) and another table for sales (i.e. the items that are going out of your inventory).  The common link is a part number (i.e. some unique number to identify each item).\n\nYou need to load each item purchased and qty. into the "purchases" table and load each item sold and qty sold into the "sales" table.  If you purchase and sell the same items over and over you can just keep adding rows to your purchases and sales table.\n\nTo see what you have on-hand you make queries that sum up all the purchases by part number and sum up all the sales by part number.  You join these together and include a formula to subtract sales from purchases.  The result is what you have on hand.\n\nDoing it this way gives you a running history of what was purchased and sold.  You never have to change or replace your original data - you just let the system do the math to tell you what's on-hand.
276665
http://greenvillesc.areaconnect.com/statistics.htm
470488
MS Access comes with some sample databases.  Other than that, you just have to look for some.
992894
Access is fully programmable, and easy to set up for small databases.  You could probably do this yourself.  I'm not sure you will find an actual "Lost and Found" database, but morelikely find an inventory control or the like.
169744
http://www.trueforex.com/calculating_pl.asp
479961
List your readings in a vertical column (you will have to decide which readings out of the up-to-6 a day you are taking, or I suppose you can average them daily using the same means I am giving you here).\n  In a blank cell by your list enter the formula =AVERAGE(r1:r7), where r1 is the first daily number and r7 is the 7th daily number.  Use the same format for 14 days (r1:r14) and 30 days (r1:r30).  If you wish to average the several daily readings, list those horizontally and, to their left, enter the =AVERAGE formula, then use those averages in your daily average formulas.
1015496
Access has the "forms" but I forget how to use it.
979610
Well, you've got the averages. You can now find the total points my multiplying the mean with 10. You can also determine the mean deviation, standard deviation, variance, co-variance etc of the data of each group and determine the relative levels of consistancy of each group and compare the spread of the data.\nFor further stuff...look it up in wikipedia.
122221
From what I can tell this is actually a fairly basic Access program (unless you want it to automatically calculate interest), however it seems you are asking how to build the whole thing; something that would take too long to explain here (I would also need additional information). \n\nI would suggest using an online tutorial (the one below looks pretty good if you have Access 2000) to learn how to use Access. This way, you can build your program however you want--since you are the only one who knows exactly what you have in mind.
566403
Microsoft Access software can do that.
495673
sure u have \nand try crystal reports\n\ni dont have to tell u the steps .. cause i dont remember really .. but try with msdn
292988
Depends on the file that needs to be imported, and how you need to import it.  Enterprise manger comes with an import wizard that you can use to import information.  sometimes it's easier to just import the whole thing and delete what you don't need/want.\n\nanother way would be to make the file into a CVS and import that into access, then by using a linked table, export the table to SQL.
144787
I will give you just the simplest possible explanation to get you started. It can be far more involved than this, however. \n\nThe Simple Arithmetic of the Moving Average\n- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -\n\nSuppose you have a string of numbers: { 0 3 1 2 5 3 2 }\n\nIf you suspect that this string of numbers contains some sort of signal, but it is hidden or obscured by noise, you can use a moving average to try to find it. \n\nFor example, suppose that at a time t, you measure a number x, to get x(t): \n\nx(1)=0 \nx(2)=3 \nx(3)=1 \nx(4)=2 \nx(5)=5 \nx(6)=3 \nx(7)=2\n\nThe t values could be seconds, for example, so t=1 is the first second, t=2 is the 2nd second, t=3 is the 3rd second, etc. Then:\n\nx(1) is the x measurement at the first second\n\nx(2) is the x measurement at the second second (that sounds funny doesn't it? )\n\nx(3) is the x measurement at the third second \n\nand so on.\n\nOne could form a moving average of these numbers, to try to find the underlying signal. Let's call the moving average y(t).\n\nLet's suppose that we will average 3 numbers x to find the number y:\n\ny(2)= (1/3)*[x(1)+x(2)+x(3)]\ny(3)= (1/3)*[x(2)+x(3)+x(4)]\ny(4)= (1/3)*[x(3)+x(4)+x(5)]\ny(5)= (1/3)*[x(4)+x(5)+x(6)]\ny(6)= (1/3)*[x(5)+x(6)+x(7)]\n\nSo you see what is happening? The three x values to be averaged are chosen to be x values in a group, and the x values chosen are shifted as the argument of y moves. The values to be averaged move as the argument of y moves,  \nso y(u) = [x(u-1)+x(u)+x(u+1)]/3. You can get fancier, and invent a method to find y(1) and y(7), although there is no x(0) or x(8) to use in the formula. \n\nExamples:\n- - - - - - - - - - - - - - - - -\n\nHow might one use this in practice? Suppose that you want to see the effect of your new traffic signal on traffic flow on the highway. You put a meter down and count how many cars pass per minute, and collect data for 10 days. You want to analyze this data and see if you can see a pattern or a trend in your data, and compare it to data from before you put in the traffic signal. Only problem is, the data are very noisy so it is hard to see a pattern. The solution? Try a moving average to smooth out the lumps in the data to see if a nice pattern emerges that you can compare with the pattern from before you put in the traffic signal. \n\nAnother example is, you are trying to listen to your friend's voice over a microphone on his computer, but there is really so much static that you can hardly hear him. Then, you could use a moving average to try to smooth out some of the noise so you could hear his voice more clearly. \n\n\nMore Advanced:\n--------------------------\n\nOne could make the number of values of x to be averaged larger. One does not have to use an arithmetic average, so another kind of average could be used, like a geometric avearge, or a harmonic average to form y. One does not have to use averages at all, so a median or a mode could be used to find the central value of the x's in the group being analyzed. This is a very simple type of low pass filter, or a procedure to remove high frequency noise and other signals from sequential data. The moving average can be computed using a mathematical technique called convolution. There is a connection between convolutions and an expansion of these measurements in terms of sine waves (called a Fourier transform) that is very interesting and useful. \n\nIf you are interested, there is a huge amount of information about this on the internet. I did not want to overwhelm you to start, however. It is best to start out really simple and understand the simple case very very well before you move on to more advanced material.
919441
Two SQL statements, which you can enter in SQL view in the Access query designer.\n\nIn these statements, col1 is the greater column, col2 is the lesser column, and table is the name of your table.\n\nSELECT col1, col2, (col1 - col2) AS profit FROM table\n\nFor the sum:\n\nSELECT SUM(col1) AS col1sum FROM table
492576
Can u elaborate the problem, The MS-Access has it own built in SQL building routine, if this is not solving your problem, then please explian the kind of connectivity or query u are passing so that i can understand it better..!
1036250
Collect the sum of the overhead for your business.\nCount how many instances of overhead.\nThe average will be the sum / count.\n\nMake a cell with the formula:\n'=SUM(start_col_row : end_col_row)'\nEg, B1 '=SUM(A1:A14)'\n\nMake another cell with this formula:\n=COUNT(start_col_row : end_col_row) '\nEg, B2 '=COUNT(A1:A14)'\n\nMake yet another cell with this formula:\n=(cell_with_sum / cell_with_count) * 100'\nEg, B3 '=(B1/B2) * 100'\n\nThis gives the average overhead in percentage, for your business.\n\nHow you do the comparison of your average vs. national average is entirely up to you.  You could just look, you could take yours away from the national, etc.