[AccessD] Re: Multiple copies of value across columns in a crosstab RePost.

Hi David

> What a clever solution! This is very neat, using the ABS function to get
> the PAX to appear or not appear depending on whether the column date is in 
> the correct range. I can't wait to try it. Thank you heaps.

You are welcome. I hope it works for you.

> I've never done a query without a join before are there any speed 
> implications?

I would guess not. But if you have millions of records ...

> Jim Hale referred to your example as a non-Cartesian join (is that right?) 
> - I must do some more research!

Yes, or maybe rather a "cartesian product" as the number of output
rows in a normal select query equals the product of the numbers of
(selected) rows of the included tables.

/gustav