Recent content by eriel3

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?