I am trying to use a running balance in a query, similar to how your checking account works. I can't figure out how to do this. Can anyone help?

We are a calibration company. We store errors into separate fields, i.e. E1, E2, ect... I need to come up with a query that calulates the Range of the error....

Is it possible to only update the year portion of a date/time field? The current dates are entered as xx/xx/xxxx, e.g. 3/5/2004, 4/22/2004, etc. All the years...

Hello everyone. I have a question where I need to create a query from an existing query...but have no idea where to start. I need to do the following: I...

Hi people, Pls help to select the following data. Tha table has subnet, address, serail# and model columns. I need to select the data where various addresses...

Hi, only a little question.Is it possible to replace the=20 Date() function with an function that compares all dates=20 so that only datasets of the last year...

I'm very sorry for reposting this, but I made a mistake on the first post and I tried to fix it with a reply. Usually whenever I reply to my own posts I never...

I created an append query to move records to a new table, I am doing this by ProjectID. It works fine but when I get to projectid 1 and 10 I get and...

Hi, I have a query that I've used forever, it is still working fine, it was created through design view. The query continues to work fine, I can access SQL...

I'm having trouble with some labels that I have created for a client that reports information to the Department of Education. Here are my tables: Students...

I'm trying to create a SQL statement that will delete all records in a table where the values in a particular field are less than the maximum value. So after...

is it possible to convert a form into a subform. When I pullled in the form into the parent, it wouldn't allow me to assign parent and child controls. Do I...

Does anyone know how to create a drop down list box for a parameter query prompt when running reports based on queries? When I run my maintenance location...

hi, gunny thank you for your help. but my items are not exactly repeated from the sources. these items may repeated only in column "title", "isbn", or...

Hi, I have to transfer a web-site to a new server. I changed nothing, but I always get this scary error: --------------- ODBC Error Code = 07001 (Wrong...

I have been trying for days to accomplish one thing..... I have a problem with finding a way to update a field in a table with the information gathered in a...

is it possible to run a "make-table" query on the results of a crosstab query? what i'm trying to do is take the results of a query and put it into excel....

Hello, I need some assistance. I have a form in access 2003 that is linked to a SQL 2000 Database. I get a #DELETED Message on the form, but the records are...

I am going nuts on this and hope someone can help. I have a query, or I should say am trying to WRITE a query where I find duplicate records between a master...

I open a query in design view in Access and make some modifications. When I close the query, it does not prompt me to save the changes. It does save the...