Search results for query: *

okay i know how to filter the data by date range, but how would i build the second query to do a total. i am not really good in sql. is there a way that i can does this in the query design view in access, that is (the second query)

yes, well what i am going to do is put in a date parameter so that i could get the total on a date range. so i guess the total for all records in the query

I am trying to write a query that will calculate the total of the field AOG. Can someone help me please. Date AOG 04/01/04 300 04/02/04 400 04/03/04 500 04/04/04 600 TOTAL 1800

Disregard everything else, in a nut shell this is what I am trying to do Date AOG 04/01/04 300 04/02/04 400 04/03/04 500 04/04/04 600 TOTAL 1800

okay, how would i do that, would i just add it to the end of the sql statement, could you show me how the sql statement should read?

okay i have a this query that is grouping the information by month and summing up the field AOG I do not want it to group by month but to group by a date range that i put in each time, how would i change this? SELECT DISTINCTROW Format$([Daily Activity-Millennium Query1].[DATE],"mmmm yyyy") AS...

okay this is what i am trying to do. i looked on the internet to see samples of grand totals. and i so this statement select O.OrderID,convert(char(10),O.OrderDate,101) 'Order Date',O.OrderAmt, case when OrderID = (select top 1 OrderId from Orders where...

Okay, sorry for not responding so soon, had to go out of town, anywho? The totals are not what i am storing, I am using the totals so that i can calculate a pricing field. This is what I am doing I need the total of AOG (fyi this is in gallons) Then I have another table with AOGPRICE What I...

I am going to store this information. Could you just have the data append to another table?

I am not trying to add them together, I want the total for each individual field. Okay, this is what I did first. I created the query by selecting each field. Then I clicked on Total. Then I changed Group By to Sum. It gives me the sum of that field per record. I want the total sum of all...

I want to get the an overall total, then save it to a new table. I have a table with four fields fields AOG, PIK, SUPP, DATE I have a query with a date criteria, and the results pull up the dates that i requested. Question? How can I get an overall total for the three fields listed, and...

thanks, i had it on long integer. just another question which is off the first subject, you wouldn't happen to know how to assign a shortcut key to a customized button on my form

Okay i think I figured out one way to take this off, here is my SQL. INSERT INTO AppendTable SELECT DISTINCTROW [Daily Activity-Millennium].* FROM [Daily Activity-Millennium], AppendTable WHERE ((([Daily Activity-Millennium].ActualForecast)="Actual")); How do I tell it to only append records...

I have a warning message that appears every time I update a query. I did go to Options and deselected all query messages, but this one is different. it says: "Microsoft can not append all records in the append query" I know this because I told the query not to accept duplicates, but I do not...

Can someone tell me how to stop data from rounding in Access97?

I have a calculation(update query) that should update after a LostFocus, but it does not update the first time, when i go back to the fields then it updates, I want it to update immediately. I have the following Field 1 = (enter a number) Field 2 = (enter a number) Field 3 = onlostfocus updates...

Okay, I kind of figured that part out, but I am not really a programmer so I do not know exactly how to tell it to exclude. I do have an Unique ID Field that can do be the identifier, could you tell me what to write to exclude. Here is my SQL: UPDATE [Daily Activity-Millennium] SET [Daily...

Can anyone help? i how do you do an update query in MS ACCESS but I only want to update the all records except for the very first record. So everytime I hit update query it will update all fields except for the first record.

Thanks for the help.

I know this is a dumb question, but hey still need the answer. I have several update queries that I want to run at one time on a form. Instead of putting 3 different buttons on my form to run this query, how can i tell it to run from the click of one button. Also, I need it to update...