NeoPa,
i am not familiar with databases or SQL at all, so i am looking at Access like it is Excel, and while i know that is wrong, i am also thinking like i can modify it like its c/c++. i am now understanding that i am wrong. with that being said, i dont really understand what you are saying about the questions.could you slow down and teach me a little bit? im sorry for my inexperience, and i am really greatful that you are taking...
SPC Camp
Last Activity: Oct 12 '10, 02:36 PM
Joined: Sep 16 '10
Location:
-
I think that gets me about 3/4 of the way there. In the report, I am querying the tables with the deficiencies, and putting that information along side the section information. I am doing it this way in order to print it out and give it to my boss so she can read it and know what section needs the most work. Also, when there was only 10 criterion, i had the tables linked so i could drop down the deficiencies table inside the section info table and...Leave a comment:
-
SPC Camp started a topic What is the best way to build a db to report a total number of true yes/nos'?in AccessWhat is the best way to build a db to report a total number of true yes/nos'?
I am trying to build a db to report the deficiencies/strengths of security. We have about 1000 criterion that we base these on. I am trying to set it up to where we can specify which criteria they are deficient in, and it will report the total number of deficiencies that section has. i have tried to do this with a yes/no field, and code that looks a little like this:
in order...Code:Sum(([a1000]+[a1001]+[a1003]+[a1002]+[a1004]+[a1005])*-1)
-
I decided on something a little less eloquent
This code gives me a count of deficiencies per dept. i have hundreds of deficiencies to track per dept, and will have well over a few hundred depts by the time i am done. Thank you for the help!Code:SELECT sum(([a3005]+[a3009]+[a1005]+[a3001]+[a3002]+[a3006]+[a1142]+[a3053]+[a1152]+[a5001])*-1) AS Totals, [Unit] FROM table_1 GROUP BY [Unit];
Leave a comment:
-
Access adds to your code when I run it.
I further modified the code to read:Code:SELECT key AS Expr1, Table_1.[A3005], Count(*) AS Expr2 FROM Table_1 WHERE (((Table_1.[A3005])<>False)) GROUP BY key, Table_1.[A3005];
...Code:SELECT Table_1.Dept AS Dept, Table_1.A3005, Table_1.A3009, Count(*) AS Totals FROM Table_1 WHERE (((Table_1.A3005)<>False)) OR (((Table_1.A3009)<>False))
Leave a comment:
-
How do I return a count of true booleans from "Table_1" in "Table_2"?
in Microsoft Access '07, I am creating a Database that tracks whether or not a specific department is deficient in specific areas. I am using Booleans in the form of check marks to annotate which departments have which deficiencies. True = Deficient, and False = Satisfactory.
I would like to summarize this data in another table that has all of the companies departments, and all of the information of said departments, in it, while stating the...
No activity results to display
Leave a comment: