Hello everybody, I need to create a query that (after it asked for the parameter "Insert year") selects the right records from the original table, inserts them...

I'm trying to write a query which moves data to a different field, i'm going to use this to update a db2 database currently our users have the option of adding...

How can I add columns without moving formulas. I need to have formulas stay in column a,b,c, When I add column formula goes to b,c,d, it needs to stay where...

Hi, Here is my query: INSERT INTO CartWeight ( WeightTotal, CartIDNumber, CartNumber ) SELECT Sum((+++++++++++)) AS Expr1, Cart.CartID, Cart.CartNumber FROM...

I have the following data and I would like to calculate moving average for 3 years to know overall impact on food price year price ...

I have a table (MarketHistoryShort) containing a large amount of historical price and volume information for a number of different stocks with the following...

I would like to add three fields to the following Query that would create a running or moving avg from the fields (columns 3, 4 & 5). The moving average...

Hi. I posted a similar question earlier in the week. I may not have explained my problem well. So I am trying again... My data table looks like...

I have a data set that has daily trading volume for a list of stocks. I would like to find a sql that will produce a 20 day moving average of all stocks NOT...

Back once again... Here is the following problem. In a query I want to calculate a moving annual total in which the total should be the sum of the previous 12...

Access 2003...Windows XP Wantng to establish a Filter by Form, I have built a query string called: 'strWhere' This was applied using: Me.Filter =...

Hi. I'm not even sure that this is possible, but here's my situation. I have data whose attributes may increase as follows. Table Defects Integer:...

Hello in a field of a table there is data entered and at the end of most entries there is a bracket with some letters inside. (AB) What I need is to remove...

I have a main table for new charges which havnt been billed which is called tblNewcharges which has the...

Hallo I hope some i can help me i have a table full of access codes so i need a query where i can say take the next 20 records out of that table and move them...

Hello, i'm using following SQL stmts to select rows from Table . When moving the code to the bookmarks in a Word Document I don't see anything appearing in my...

Sometimes I need move records from one table to another table. I always need to insert into and delete from 2 queries to complete the task. Are there any...

I am trying to write a query to take the following table: Part Description 1001 BHJ, UI 1002 GU, SI, PQ 1003 YU, JU And write it in the following...

Hi All, I am using the code below to move up the items in a list box named lstSelected (for the move down, I just use the reverse ) But I keep getting an...

After parsing i move the values form tblcustomer to tblRequest. There are too many spaces in all the field of tblcustomer but they all move good accept field...