appending a Learner and Aims set of records to a txt file

[Rob DSO Llandrillo]

I need to create a fixed width text file in the format:
Learner details record
Learner aims record
Learner aims record
Learner aims record
Next Learner details record
learner aims record
learner aims record
etc

the learner data and aims data is held in 2 seperate tables, how do i get
access to append the learner record then any associated aims, then the next
learners record and the associated aims, etc. ?????

i suspect this will be some VB but i am a novice in the use of VB, although
attending a course at the end of the month, so any help much appreciated.

Rob

 

[Evi]

If your database structure is correct, you shouldn't need to append anything
to a table. You can put these details into into a report grouped by learner
details record, then go to file, Export and choose text file. Or if
preferred, click the Analyze in Excel button (if you don't have acc2007)
Evi

 

[Rob DSO Llandrillo]

Hi Evi,
i tried that - forgot to mention it.

Access wont allow me to create the report because there are too many fields.
there are 48 Learner fields and 60 Aims fields :-(

otherwise it would have been fairly straightforward as you suggested.

thanks for the reply though

Rob

 

[Rob DSO Llandrillo]

my apologies Evi - i was trying to use the report wizard to do it and it
wouldnt let me (trying to do it too quickly).

if i design the report from scratch it works, so just need to get it to out
put in the right format now.

thanks
Rob

 

[Evi]

I do understand Rob, I too have assumed that if the Wizard wouldn't let me
do it, then it couldn't be done. Do you have Acc2007? If not, I'd have
thought that your best bet was an export to Excel and when there, Save As a
csv file - they tend to be fairly universal currency.

I'm still a bit concerned that you may have a design problem. It would be a
shame to build up lots of stuff in your db only to have to tear it down
later if you need to redesign. Do you think it possible that some of your
fields should actually be seperate records? eg If you have learning aims,
then the steps to achieve that learning aim would not be seperate fields but
a series of records in a linked table which will be appended to a
StudentSteps table to be filled in with data about how and when the student
achieved each step
Evi