P
Purley Academic
Hi,
I have a basic tab file with a column that records the number of cases. What
I would like to do is to create one record per the number of cases in the
original field. So if the cases field states that I have 64 records I would
need to create 63 further records each with one case.
I'm assuming that a niffty piece of SQL would sort this out, but I seem to
be stuck at the moment.
I have a basic tab file with a column that records the number of cases. What
I would like to do is to create one record per the number of cases in the
original field. So if the cases field states that I have 64 records I would
need to create 63 further records each with one case.
I'm assuming that a niffty piece of SQL would sort this out, but I seem to
be stuck at the moment.