In Access, how do I create a query to have a value subtract from another value?
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
125012
If you know that the column name exists in the table that is used in the query, then possibly the column that you are comparing is a CHAR type of column.  In that case, make sure that you surround the data with single quotes.\n\nSELECT * FROM SomeCharTable WHERE SomeColumn='ABC123'\n\nThe above should work for a column that is a CHAR type column.  It is important to put the single quote (') around the text.  Note, in the example above, "SomeColumn" must be a column that exists in the table "SomeCharTable".
881584
For a small business you could either simply use an excel sheet, where u divide up the columns you need and use the calculation symbols for ease of any calculations. You can sum up, subtract etc easily. Just use the help/office assistant in Microsoft excel.\n\nAlternatively use SQL database system, you can get a person trained in software to create an sql system for you which will be quite easy to use and help in costs and all other functions for your data.
775038
Nope, sorry.  What you're describing is a query.  Only Access can do that.  It's a pretty simple one, and exporting back and forth between Access and Excel is pretty easy.  If you want some help in how to do it, send me a message.
391107
USe the function "CountIF"\n\ne-mail me for more details
1124819
Create a new field in the property table called Address:\n\nalter table property add Address char(50);\n\nThe above assumes the data type is char(50).\n\nUpdate that new field equal to street number and street name:\n\nupdate property set Address = concat (Street_Num, ' ', Street_Name);\n\nAssumes that Street_Num and Street_Name represents street number and street name, respectively.\n\nThis assumes MySQL syntax.  The exact concatenate syntax is database-dependent.
830897
Use this formula\n="<< " & INT(A1/60) & " : " & A1-INT(A1/60)*60 & " >>"\nChange A1 to the cell containing the value.
513723
A field within a table.
703752
simply subtract 7 from both sides. This leave you with\n\nx<_3
421773
MS access will do that, \n\nlookfor help in excel for JET or OBDC
697117
Subtract the cells and format it as numeric
1150128
Create an expression field in your query with the expression DateString: Format([DATE],"yyyymmdd")\n\nWhere DateString is whatever you choose to name the field and [DATE] is the name of the field you need to express as a string.\n\nIt may also be possible to create an Input mask in the format you want but I failed to hack that! The above is by far the easiest and most logical method, anyway, since you want to represent the data already in a table, not change the way it is input.
166806
use query to create sum of quantities...
396944
Access 97 supports only limited SQL queries. Most of these can be generated with the query designer functionality in Access, but if you want to access the database using more advance SQL commands, try writing a VB program to do it and use an OLEDB jet connection. Then you get whatever functionatily you want on it.\nGood luck!
765887
Assuming your above program works, which I don't think it will because your doing an aggregate operation on an array..you should assign values to indexes in the array...eg cin >> Date[0] or use a for loop or something...regardless since your putting everything in an array anyway simply do something like using a counter variable, personally i think it would be the easiest way of doing something like that.\n\nint counter = 0;\n\ncout << enter day to subtract << endl;\ncin   >> counter;\ncout << Date[1]  - Date[counter] << endl;\n\nI belive using
226941
Place the cursor in the first column of the row column descriptions, nagivate to DATA>FILTER->Auto Filter (select).  Now move to the column with say Pet type and Select "Kitten".  Move to the column with Stock balances and select Custom->Less than or equal To and enter 100. I hope this helps and answers the question.
622069
Above answer is ok except for not using the -- operator:\nNeed to start at 10 and to decrement i use the statement:\n\ni--;\n\nThis changes the problem somewhat.  Another problem in the first answer is that fact is not initialized, so it will always equal zero resulting in a division by zero error.