[AccessD] Problem Making Query

[Charlotte Foust]

If Active and Complete are the only two conditions, you could use a couple
of subqueries to check for the two conditions (any active and all complete)
and apply the criteria you need to filter.  One query and two subqueries.
Just select for whichever criteria you want to filter or no  criteria for
all.

Charlotte

Charlotte Foust
(916) 206-4336

On Fri, Dec 11, 2015 at 8:50 AM, Rocky Smolin <rockysmolin at bchacc.com>
wrote:

> 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
>