[AccessD] Problem Making Query

Rocky Smolin rockysmolin at bchacc.com
Fri Dec 11 12:15:41 CST 2015


I thought so - initially - use a summation query to count the active or
complete but I couldn't get it to work.

The example case was a project with two activities - one active on complete.
That one should com up on the active list. 

r 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of FW
Salato Center
Sent: Friday, December 11, 2015 9:21 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Problem Making Query

Could this be simplified with a simple count -- if no ACTIVE, assumed
COMPLETE????

Susan H. 

Dear List:
 
I need some help structuring 2 queries and can't seem to figure how to do
it.  
 
I have two tables: Projects and Project Activities, where Project Activities
has the FK of Project ID - PK in the project table.  
 
Activities table has a status field 'ACTIVE' or 'COMPLETE'
 
The client wants to add checkboxes on the calling form - one labeled
'Active', one  labeled 'Complete', so that the combo box of Projects on the
called form will show only Active projects, only Complete projects or both.
 
Showing both is easy - I already had that before he thought up this dandy
enhancement
 
A project is Active if ANY project activity is status = ACTIVE.
 
A project is complete if ALL activities are status = COMPLETE.
 
So I'm trying to create two queries - one which would list active projects
and one which would list complete project per the definition above then I'll
change the row source of the combo box based on which boxes are checked.
 
But I've been fooling around with it long enough without success that I
think I need some help.
 
(help!)
 
MTIA,
 
Rocky Smolin
Beach Access Software
858-259-4334
www.bchacc.com <http://www.bchacc.com/> www.e-z-mrp.com
<http://www.e-z-mrp.com/>
Skype: rocky.smolin
 
 
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus



More information about the AccessD mailing list