vb

• • Reply

  19 years ago

  by nathan

  nathan

  london, United Kingdom

  Joined 19 years ago

  any body there to help me pleaseeee?
  

  
  hi,  i am currently involved in a project ,where need to read multiple data base(access) files with numeric values and need to get the average of them and to produce  a hard copy of various graps(bar,line). could any body help me or have idea how to do?. can contact me directly at [email protected].
  many thanks in advance
  

  
  regards
  nathan
  

  Report abuse
• • Reply

  19 years ago

  by tlosekoot

  Thamar

  Poland, Poland

  Joined 19 years ago

  Hi!
  

  
  There's two ways to do this, depending on the databases you're working with...
  

  
  1. In case all the databases have EXACTLY the same table structures, you could very easyily (using an APPEND QUERY) add all databases to a new, empty one and then generate the reports. In case they're not completely the same but much alike that's also possible this way.
  

  
  2. In case the databases are different, but you still want to be able to link the data try making a connection between them all in an empty database. Use FILE-IMPORT-LINK TABLES for this... Don't remember you'll need to have at least one field where the record ID's are the same...
  

  
  Need any more detailed help, just gimme a sign.
  

  
  Good luck!
  

  
  regards,
  

  
  Thamar

  Report abuse