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

David Fenton dfenton at ozemail.com.au
Thu Jun 24 06:25:27 CDT 2004


Gidday Gustav,
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.

I've never done a query without a join before are there any speed 
implications?
Jim Hale referred to your example as a non-Cartesian join (is that right?) 
- I must do some more research!

Cheers
David
Australia




More information about the AccessD mailing list