Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. desmur

    AVG in reports

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

    AVG in reports

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

    AVG in reports

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

    AVG in reports

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

    Unable to receive mail

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

    Missing Mail

    Well, there are no ost files or roaming profiles.
  7. desmur

    Missing Mail

    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?
  8. desmur

    Unable to receive mail

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

    Compaq Smartstart CD v5.3

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

    OST file

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

    3 queries into one

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

    3 queries into one

    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 =...
  13. desmur

    3 queries into one

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

    Access Denied

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

    Count number of days

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

    Query Problem

    That did it. Thanks for the info.
  17. desmur

    Query Problem

    SELECT qrytotalhours.emp_last, qrytotalhours.emp_first, tblClient.client_name, [emp_first] & " " & [emp_last] AS employee, tblTimeSheet.ts_emp_id, tblSalary.emp_brate, tblTimeSheet.ts_pay_dte, qrytotalhours.SumOfts_hrs, tblTimeSheet.ts_hrs, IIf([exp_amount] Is Null,0,[exp_amount]) AS...
  18. desmur

    Query Problem

    I am trying to do a simple calculation in a query. it is dividing one field by another to come up with a rate. When I do that I get a message box that says "This expression is typed incorrectly, or is too complex to be evaluated. For example and numeric expression may contain too many...
  19. desmur

    Rounding Problems

    None of this worked, let me explain it better. [payrate]/[billrate] in a query returns a value of .6875 but I need it to return a value of .69. Now it displays .69 because I set the format to fixed with 2 decimals but I need it to calculate to .69. Can you give me the syntax to do this and...
  20. desmur

    Rounding Problems

    I am not able to get that to work, let me explain what I need to do. I have a calculation in query of [billrate] / [payrate]. This rate returns a value of multiple decimal places. I only want it to return two decimal places. I want it to just seem like it by changing the formatting to fixed...

Part and Inventory Search

Back
Top