Tilted Forum Project Discussion Community

Tilted Forum Project Discussion Community (https://thetfp.com/tfp/)
-   Tilted Technology (https://thetfp.com/tfp/tilted-technology/)
-   -   [Access]I need some Database help... (https://thetfp.com/tfp/tilted-technology/87637-access-i-need-some-database-help.html)

j0hnb 04-20-2005 08:19 PM

[Access]I need some Database help...
 
I have a database that I need someone to look over for me. It is a sample project manager database. It is filled it with sample data, and has a few queries, but I am having trouble with a few parts of it, and I was woundering if anyone would be able to double check my work and relationships. It is a small database, with only 8 tables. I uploaded a copy of it so if someone could take a quick look at it that would be great.
http://smoothdesigners.com/ProjectManager.zip
Also if you could IM me my screen name is j0hnbanks .

This what the queries are supposed to return.
Q1:A listing of projects, milestones, and status
(Can't get it correct, bad querie in place)
Q2:A listing of projects, milestones, lead employees, and status for those milestones not completed, grouped by project.
(Seems correct)
Q3:A listing of a project with milestone steps and status.
(Seems correct)

Thanks for any help that you can provide.
-John

Bamrak 04-21-2005 03:32 PM

The relationships look good, here's your querys. it would also help to use a standard naming convention and give the query's descriptive names, or at least fill in the description. Your Queries are as follows:

Q1- you need a grouping to get rid of your duplicate rows.. like this:

SELECT Project.Name AS Project_Name, Milestone.Name AS Milestone_Name, Steps.Status_Complete
FROM (Milestone INNER JOIN Steps ON Milestone.MilestoneID = Steps.MilestoneID) INNER JOIN Project ON Milestone.MilestoneID = Project.MilestoneID
GROUP BY Project.Name, Milestone.Name, Steps.Status_Complete;

Q2- looks correct

Q3 also seems correct


All times are GMT -8. The time now is 05:11 AM.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
Search Engine Optimization by vBSEO 3.6.0 PL2
© 2002-2012 Tilted Forum Project


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73