Re: getting more rows out of a table

Richard Harnden. Legend! Thank you so much for your help. I spend so long trying to avoid cartesian products, I don't spot when one might actually be useful!! I couldn't actually use the create function. Maybe the designers have locked this down on my ace report machine. However an existing table had all the data I needed to create a temporary table and then use this to create the formulas you posted. Thanks again. Couldn't have done this without your help.