Results 1 to 9 of 9
  1. #1
    samyshf is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2021
    Posts
    5

    Dúvida sobre criação de tabelas de consulta


    Como posso criar uma tabela de consulta, com dados extraidos de varias tabelas diferentes? ou seja pegar diversas tabelas com varios dados, escoher 1 de cada tabela e entregar a media total desses dados de todas as tabelas, e nao 1 por 1?

    Tenho uma coluna com o nome das amostras, e outra coluna de conservação, eu preciso entregar uma média dessa coluna de conversação, dessas amostras com nomes e o mesmo nome e conversação aparecem em 10 tabelas diferentes. Tem como eu ficar essa tabela de consulta um a média de todas as tabelas?

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Google translated version:

    How can I create a lookup table, with data extracted from several different tables? that is, take several tables with various data, choose 1 from each table and deliver the total average of that data from all tables, and not 1 by 1?

    I have a column with the name of the samples, and another column for conservation, I need to deliver an average of this conversation column, these samples with names and the same name and conversation appear in 10 different tables. How can I get this query table an average of all tables?

  3. #3
    samyshf is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2021
    Posts
    5
    Sua resposta veio com a minha pergunta

  4. #4
    orange's Avatar
    orange is online now Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Since 99+% of the forum is English, I thought I'd post the question so readers could understand it.
    Not enough info nor details to offer focused suggestions.

    Como mais de 99% do fórum é em inglês, pensei em postar a pergunta para que os leitores pudessem entendê-la. Não há informações ou detalhes suficientes para oferecer sugestões específicas.

  5. #5
    samyshf is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2021
    Posts
    5
    Okay, but my English is bad, and most of the translator. I have this database: https://drive.google.com/file/d/1G8z...ew?usp=sharing and I would like to create queries from the average of each sample, https://drive.google.com/file/d/1b92...ew?usp=sharing

    And how to select these guidelines: https://drive.google.com/file/d/1Yub...ew?usp=sharing How this final code was made: https://drive.google.com/file/d/1AL6...ew?usp=sharing

  6. #6
    samyshf is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2021
    Posts
    5
    Well, my English is bad... I have several tables with the same samples, which were extracted in different ways, but they are the same samples: https://drive.google.com/file/d/1b92...ew?usp=sharing as you can see, I can create a query, from the Mycerne sample, from table B1C1: https://drive.google.com/file/d/1Kbz...ew?usp=sharing I wanted to take all the tables and take an average of the samples, and not only from B1C1, because all the tables have the same samples, only the form of extraction changes. I would also like to know how this search: https://drive.google.com/file/d/1Yub...ew?usp=sharing returned this result with the averages:https://drive.google.com/file/d/1AL6...ew?usp=sharing it's a job test and I really want to pass it, and I haven't accessed Access in years, but I can learn again, but I need to pass the test.

  7. #7
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Quote Originally Posted by samyshf View Post
    Okay, but my English is bad, and most of the translator. I have this database: https://drive.google.com/file/d/1G8z...ew?usp=sharing and I would like to create queries from the average of each sample, https://drive.google.com/file/d/1b92...ew?usp=sharing

    And how to select these guidelines: https://drive.google.com/file/d/1Yub...ew?usp=sharing How this final code was made: https://drive.google.com/file/d/1AL6...ew?usp=sharing
    You might be better to attach your files to a post here. For instructions see: https://www.accessforums.net/showthread.php?t=70301
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  8. #8
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Post 6 was moderated, I'm posting to trigger email notifications.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  9. #9
    samyshf is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2021
    Posts
    5
    Follow the attachments instead of the Drive links.Click image for larger version. 

Name:	consultab1c1.png 
Views:	14 
Size:	29.9 KB 
ID:	45155Click image for larger version. 

Name:	all the tables.png 
Views:	14 
Size:	21.7 KB 
ID:	45157Click image for larger version. 

Name:	initial guidelines.jpg 
Views:	14 
Size:	92.4 KB 
ID:	45158Click image for larger version. 

Name:	final guidelines.png 
Views:	14 
Size:	15.7 KB 
ID:	45159

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Duvida com meu sistema
    By carlosbell10 in forum Access
    Replies: 10
    Last Post: 10-13-2020, 06:25 PM
  2. Consulta, coluna Calculada "complicada'
    By Zaccariotto in forum Queries
    Replies: 2
    Last Post: 04-27-2020, 09:09 AM
  3. query - Juntar tabelas
    By joanas in forum Access
    Replies: 1
    Last Post: 02-25-2015, 03:42 PM
  4. Replies: 3
    Last Post: 09-17-2012, 10:14 AM
  5. reporte en base a consulta cruzada
    By ute in forum Reports
    Replies: 2
    Last Post: 04-29-2009, 03:51 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums