 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / April 2008appending a Learner and Aims set of records to a txt file
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 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 > I need to create a fixed width text file in the format: > Learner details record [quoted text clipped - 14 lines] > > Rob 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  SignatureRob Corbett Data Systems Officer Coleg Llandrillo Cymru > 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 [quoted text clipped - 21 lines] > > > > Rob 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 SignatureRob Corbett Data Systems Officer Coleg Llandrillo Cymru > Hi Evi, > i tried that - forgot to mention it. [quoted text clipped - 33 lines] > > > > > > Rob 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 > 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). [quoted text clipped - 51 lines] > > > > > > > > Rob |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.