General Networking/Lan/Wan/access

Advertisement


Question
query
query  
Hi Scott, I have attached a pdf file with my query so that you are able to see the screen dumps.
Thanks, kary

Answer
For the first issue, Are you using the AVG function or are you using (a1+a2+a3)/3. If the latter you can use a DCount to count the number of non zero Assignments instead of hard coding the divisor.

For the second issue, can you show me the SQL for query?

Hope this helps,
Scott<>
Blog: http://scottgem.wordpress.com
Website: http://www.diamondassoc.com
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA

General Networking/Lan/Wan

All Answers


Answers by Expert:


Ask Experts

Volunteer


Scottgem

Expertise

Most general questions on LANs, especially home networks. Some admin and design issue.

Experience

I've been an IT Professional for more then 16 years. I've accumulated a larege store of knowledge that allows me to answer a wide variety of IT related questions.

©2016 About.com. All rights reserved.