Roman F
asked on
Help with ms access query
Hi, experts.
I have a simple database.
I have two queries:
qryRec_Last--------------- shows how many projects received
qryPro_Last--------------- shows how many projects completed
select Count(qryRec_Last_1.projec tId) AS Count FROM qryRec_Last_1
------->60
select Count(qryPro_Last_1.projec tId) AS FROM qryPro_Last_1;
------->30
i want to write a query showing:
Received Completed %
60 30 50%
Thanks
I have a simple database.
I have two queries:
qryRec_Last---------------
qryPro_Last---------------
select Count(qryRec_Last_1.projec
------->60
select Count(qryPro_Last_1.projec
------->30
i want to write a query showing:
Received Completed %
60 30 50%
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
what is the name of the table where based your two queries?
post the sql of the two queries.
post the sql of the two queries.
ASKER
select Count(qryRec_Last_1.projec tId) AS Count FROM qryRec_Last_1
select Count(qryPro_Last_1.projec tId) AS FROM qryPro_Last_1;
select Count(qryPro_Last_1.projec
what is the name of the table where based your two queries?
post the sql of the two queries.
"qryRec_Last_1"
"qryPro_Last_1"
post the sql of the two queries.
"qryRec_Last_1"
"qryPro_Last_1"
ASKER
' qryPro_Last_1
SELECT
DISTINCT DataExtr.StatusCreatedByUs er, DataExtr.StartStatus, DataExtr.EndStatus, DataExtr.StartDate, DataExtr.projectId, Format([StartDate],"mm/dd/ yyyy") AS DatePortion
FROM DataExtr
WHERE (((DataExtr.StatusCreatedB yUser) In ("GR","Cs","Jr")) AND ((DataExtr.StartStatus)="1 5 - Project Completion") AND ((DataExtr.EndStatus)="Inv oice Approved") AND ((Format([StartDate],"mm/d d/yyyy")) Between "01/06/2014" And "01/10/2014") AND ((Format([StartDate],"yyyy "))="2014" ))
ORDER BY DataExtr.StartDate, DataExtr.projectId;
'qryRec_Last_1
SELECT DataExtr.projectId, DataExtr.EndStatus, TimeValue([StartDate]) AS [Time], DataExtr.StartDate, IIf(TimeValue([StartDate]) <=#12/30/1 899 15:0:0#,[StartDate],DateAd d("h",12,[ StartDate] )) AS New, Format([StartDate],"mm/dd/ yyyy") AS JustDate
FROM DataExtr
WHERE (((DataExtr.EndStatus)="06 a - Implementer Verified Measures") AND ((Format([StartDate],"mm/d d/yyyy")) Between "01/02/2014" And "01/10/2014"))
ORDER BY DataExtr.projectId, DataExtr.StartDate DESC;
SELECT
DISTINCT DataExtr.StatusCreatedByUs
FROM DataExtr
WHERE (((DataExtr.StatusCreatedB
ORDER BY DataExtr.StartDate, DataExtr.projectId;
'qryRec_Last_1
SELECT DataExtr.projectId, DataExtr.EndStatus, TimeValue([StartDate]) AS [Time], DataExtr.StartDate, IIf(TimeValue([StartDate])
FROM DataExtr
WHERE (((DataExtr.EndStatus)="06
ORDER BY DataExtr.projectId, DataExtr.StartDate DESC;
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
If i copy exactly what you put, i am getting the error...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Received Completed %
60 30 50%