Recent content by desmur

How can I tell it to generate the totals per person in a query?

When I do this, it prompts me like it doesn't know what that text box is.

I understand that AVG, averages the number of records in the field and it is not doing that. This is an example of what I am trying to do. There are four records in the footer and I want an average of these records, not all the records in the detail section. I'm not even showing the detail...

I need to find out how to get the average of the number of records in a footer. When I try to use avg, it give me the average of the total number of records in the detail group. I am not showing the detail because I just want totals per person. Let me know if I need to explain a little...

Thanks for all your help, the problem has been solved. It turns out that one of our other servers had a setting in it that was stopping the mail.

Well, there are no ost files or roaming profiles.

I have a user who came in to work today after being out two days. All of the mail in her inbox was gone. Mail is being saved to the exchange server. No backup, nothing in deleted items. Any ideas?

HELP, all of a sudden, we are unable to receive outside e-mail. We can send and receive internal all day long, we can even send to the outside. WE just can't receive. We are running exchange 5.5 with service pack 4 on a 2000 server.

Has anyone worked with this CD. Trying to rebuild my server and when I start to load drivers, it continues to say that it can't find the cd.

I had a profile get corrupted and now I can't find the e-mails. I did find an ost file. How can I get this info to become a pst

Thanks for your help, but I am now very confused. What I did was make the sql on one line so I would not have to use the _ and ", but now it seems like you are saying that I have to get the strings inside the sql but not in the quotes?????? Here is my query again but even though it is...

Thanks for the hlep, but I'm still not catching on. Here is my code Public Function RunMyQueries() Dim strMSG1 As String Dim strMSG2 As String Dim strInput1 As String Dim strInput2 As String strMSG1 = "Enter start date" strMSG2 = "Enter end date" strInput1 =...

I have created three queries. 1 make table query 1 delete query and then another make table query. I have then created a macro do just do all the queries one after the other. The only problem is that I have parameters in each query to filter out certain dates. It is the same date for each...

I am trying to transfer files from a NT 4.0 server which is the pdc to a Windows 2000 server. When trying to do this, I get an access denied.

I need a query that will count the number of days when giving a beginning date and an ending date. What can I do.