Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2009
    Posts
    2

    Problem in Query

    Hi,

    I created one query, but when I change the data for one row, the others rows with same data that I change, change too.

    For example, I have two columns Name and Mobile number.

    Name Mobile
    Bruno Trindade 123456789
    Bruno Trindade 548645485

    If I change Bruno Trindade in first row to another name, the name in second row change too.



    Can you help me with this?

    Regards.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    It sounds more like you are talking about a Continuous Form with Unbound controls and not a query. What is the SQL for the query and how are you displaying it?
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  3. #3
    rommelgenlight is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Mar 2009
    Posts
    77
    yes. ruralguy could be right. be sure you know what you question is so that we can assist you better.

    tables are tables, queries are queries and forms are forms. You should first know what they are.

  4. #4
    Join Date
    Mar 2009
    Posts
    2
    Quote Originally Posted by rommelgenlight View Post
    yes. ruralguy could be right. be sure you know what you question is so that we can assist you better.

    tables are tables, queries are queries and forms are forms. You should first know what they are.

    Hi,

    You're right, maybe I didn't explain correctly.

    I've several table, I build one query using this SQL:

    SELECT Utilizadores.Utilizador, Utilizadores.Local, Equipamentos.Marca, Equipamentos.Modelo, Equipamentos.IMEI, Cartoes.N_Cartao, Equipamentos.Data, Packs.Tarifario & '_' & Packs.Numero AS Tarifario_Final, EstDistCont.Distrito
    FROM (Utilizadores LEFT JOIN EstDistCont ON Utilizadores.Local = EstDistCont.ID) LEFT JOIN ((Equipamentos LEFT JOIN Cartoes ON Equipamentos.ID = Cartoes.ID_Equipamento) LEFT JOIN Packs ON Cartoes.ID_Tarifario = Packs.ID) ON Utilizadores.ID = Equipamentos.ID_Utilizador;

    After this I created one form based on this query and in the form I've two rows where Utilizador is Bruno Trindade, because I have two mobile numbers. If I change the first row, where appears Bruno Trindade, to another utilizador(user) for example John, the second row replace Bruno Trindade to John too, but I only want to change the first row.

    Is it clearly to you guys?

  5. #5
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    Nope! Just as confused as before. If you open the query in datasheet mode, do you get the same results as with the form? What is the Default View of your form?
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

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

Similar Threads

  1. Problem with Report Based on a Query
    By gmalaret in forum Reports
    Replies: 1
    Last Post: 11-25-2008, 08:38 AM
  2. Update Query problem
    By sollem1 in forum Queries
    Replies: 0
    Last Post: 11-08-2007, 10:16 AM
  3. problem with query size
    By acheo in forum Queries
    Replies: 0
    Last Post: 04-11-2007, 10:46 AM
  4. Is this a Query or Sorting problem?
    By bwrobel in forum Queries
    Replies: 2
    Last Post: 07-14-2006, 08:15 AM
  5. query problem, oppointments for one week
    By keithsrobinson in forum Queries
    Replies: 2
    Last Post: 02-18-2006, 02:28 PM

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