i've just designed a vb6 app with the data being saved in a flat dbase.
The app is designed to record basic apprenticeship details such as trainee, name etc.
It also has information on the Units the trainee achieved (date) as well as claim period info (Period 1 to 12 as a number)
Trainees can in effect achieve various units in a variety of periods and be claimed for. So I end up with repeating data as in Period numbers.
The columns are PC111 (date) and PC111Claim (number) and so on, up to PC522 and PC522Claim. A total of 40 different columns.
Now i need to retrieve the data via sql, where I need the name of the trainee and any period searched for , such as a period = 1 search should return all trainees claimed for as well as their name and the date of claim as well as the units (PCxxx).
The problem is that the various columns have repetitive values such as '1', '2' etc., spread over the whole of the data fields.
I've tried many different approaches, but seem to drop records as I increase the sql code.
I've been on this for days and get more and more frustrated. Please help.
