Recent content by 1234adam

Or how do you refer to a cell one row above another. I can get this weeks average but I want last weeks, which is the prior record and just one cell above the current week in a query table.

I am trying to write a query with several different fields. Some of the fields are linked to the current date. My problem is that one of the fields is an average of the prior week. I already have a query where the weekly averages are calculated. What I do not know how to do is to link Date() to...

Thanks That was pretty simple, must of had a brain fart

Is it possible to show multiple records in a form. My table consits of many vendors. A specific vendor may be listed many times (in some cases more than twenty). Is there a way to find a vendor and then have all of his transactions shown in one form.

I am just using macros to perform the button functions. It is the same thing with the space bar. I have tried the accelerater also but it does not work the way I would like. What I have noticed is that the focus does not stay on the form. I don't know if it is because of the subform or what...

I have my tab order set the way I want to but the problem is I would like to enter on the command buttons but it won't let me. The first button is "Lastest Entry" the next button is "New Entry". When I open my form it starts on "Latest" but will not do anything on enter, I have to click it with...

Thanks very much for the example it was very helpful.

What i want is when i open up a form i want an existing internet site to show up on my form. Is this possible. If so how do i do it.

I have 8 fields and i would like to make 8 more fields each one being the change in a field. I would like my table to look like this Date..........Field1..........Change..........Field2..........Change 1-1..............5..........................................7...

I am trying to write an expression that would give me the average of the eight prior weeks. But i only want to have it calculated on fridays. So i have started the expression with this =IIF(6=Weekday([Date]),I WANT THE AVG CALCULATED HERE," ") Thanks for any help

I don't need to calculate a date. Maybe this will help. Date: 1-6-04 Field 1--------- Field 2 Date----------- Number Served 1-1-04-------- 12 1-2-04-------- 9 1-3-04-------- 13 1-4-04--------...

xxx xxx I do not know how to go about this, hopefully some one can help. When opening up the form I would like to see the whole weeks worth of data. Sunday's through Saturday. What i would want it to do is when you pick the thursday date there would be seven different records shown. One for...

I have several years of data. I don't want the average of the all the data. On a given day, the average for that day is the average of the prior four weeks.

undefinedundefinedundefined :confused: I have a problem. I want to create a query that has some complicated calculations. One of my fields i want to be an average. This average is a 4 week average based off of the prior 4 weeks. The weeks are just monday through friday. So in a given week the...