1 2 Previous Next 15 Replies Latest reply on Nov 19, 2013 2:00 PM by kettan Go to original post
      • 15. Re: Re: Re: Create a date range between date start and date end fields

        While it works, I realize now that there may not be any benefit to do it this way as compared to the way you had it.  Any thoughts?

        In this case, your union will probably do just as well as a cross join. The benefit with union is it is simpler to understand when there are only a few unions.


        The disadvantages with unions (compared with cross join) can be:


        (1) time-consuming to modify

        (2) easier to make errors when modifying

        (3) performance might be considerably slower

        (4) provokes Jet SQL to go on strike

        (5) difficult to understand when the unions are too many

        1 2 Previous Next