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...
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.
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 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...
I understand how to get numbers to show as rounded numbers but how can I use that rounded number in my calculation instead of the number with all the digits.
I need to reference a select case statement in my sql query in access. I used a select case in a public procedure. It compares hours worked to percentage paid. Once this is determined it then compares this rate to the rate currently paid and takes the higher rate. I would like to have this...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.