[AccessD] A tricky query, for me!

I would create 4 queries.

The first 3 are totals queries

Query 1 just selects all the categories and groups by that.

Query 2 selects only the hypermarket items including any that overlap
with the supermarket items

Query 3 selects only the supermarket items including any that overlap
with the hypermarket items

Query 4 pulls them all together. It's input are the first three
queries with outer joins from query 1 to query 2 and from query 1 to
query 3 both on the category field and both saying "give me all the
records in query 1 even if there are no matches in query 2 or query 3"

Then in the results grid of the query design screen you include the
category name from query 2 and from query 3 and you should see them
side by side with blanks on the side that doesn't apply for that
category. If you want a the category to display for every line, use
the one from query 1 too.

I hope that makes sense.

GK

On Wed, Jul 15, 2009 at 10:45 AM, philippe pons<phpons at gmail.com> wrote:
> Hi all,
>
> I have products that are grouped by categories.
> I consider the categories.
>
> There are 2 main groups of categories:
> 1-categories for hypermarket
> 2-categories for supermarket
>
> there is a set of categories that are in both groups.
> but they are also categories that are for hyper only and other for super
> only.
>
> I need to display both lists side by side, in an alphabetic order.
>
> But a further constraint(and this is where I need aspirin!):
> a single line must show the same category name.
> if a category does not exist in the other group, there must a blank in its
> cell.
>
> A simple question: I would you do that?
>
> TIA,
>
> Philippe
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Gary Kjos
garykjos at gmail.com