Search results

  1. S

    Update Query

    I forgot to update this yesterday but I manager to figure it out but Thanks pwbrown thats exactly what I used.
  2. S

    Update Query

    Sorry about that. I an wanting a query where it looks at 2 individual columns in 2 different tables. If they match I want the query to replace a different field which is the status. Does that make any sence.
  3. S

    Update Query

    Hi Thanks for that, I've ok with the principles its just the code or query I need help on. The port fields are the exact same. I require the code so it looks up field from Customer_ID field and if it matches the field on the Ports table it changes another field from available to working.
  4. S

    Update Field

    I'm wondering if somebody can help me. I'm building a database for work. I have 2 tables which are called "Customer_ID" and "Ports". The Customer_ID table has "CUST_ID, PORT, TICKET_ID" The Ports table has "PORT, STATUS" The tables are linked via "PORT". I have a form with 2 subforms for...
  5. S

    Update Query

    I'm wondering if somebody can help me. I'm building a database for work. I have 2 tables which are called "Customer_ID" and "Ports". The Customer_ID table has "CUST_ID, PORT, TICKET_ID" The Ports table has "PORT, STATUS" The tables are linked via "PORT". I have a form with 2 subforms for...
Back
Top Bottom