Search results

Thanks once again John. :) Your solution worked like a charm. I had another question that maybe you could provide me some input. I have a table where the first row contains dates, the remaining rows in the table have sales volumes. What I would like to do is group the sales by particular...

Thanks for the suggestion John. I shall try it when i get back to work tomorrow. It looks like a real no brainer, i guess i was just brain dead. Thanks again.

Hi Guys, I was wondering if there is any way to solve this problem. I have two tables in my db. tbl1 has fields name, qty, date tbl2 has fields start date, end date, classification eg tbl1 xxx 2 12/03/03 yyy 4 01/04/04 tbl2 11/29/03 12/31/03 j11 01/01/04 02/02/04 f01 What I need to do is...