Search results for 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

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...

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...

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...

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.

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...

I am trying to create a search form in Access that you can put several in criteria to return information. I created the form with unbound fields: txtArea txtSubarea txtType txtEquipment Then I set-up the query to say the following for each field [forms]![search]![txtArea] Or...

I am trying to do a running sum or total in Access in a report. What I trying to do is keep a log of available inventory. The table field are TotalMeth TotalTake AvailableInv which is (the previous inventory + totalmeth - total take) Can anyone help me?

I am trying to append a just one record to a new table. But everytime I append it appends the whole table. How to I tell it to append the current record. Actually, I would like for it to append from a form when a person hits save. As you can tell, i am not a programmer, but I do understand a...