Search results

  1. E

    Run SQL query for each field in table

    Hi! Could anyone help me with this: I have a table with 50 fields (all text) and I would like to run an update query on all of these, here's an example: UPDATE Sheet1 SET Sheet1.[28] = 0 WHERE (((Sheet1.[28])="")); The fields are numbered 1-50 I appreciate any help Thanks
  2. E

    Calculations with many-to-many relationship

    Hi! I tried to search for this but I am not sure how to search for this kind of problem as English is not my first language, sorry :) I have this kind of situation: I have a many-to-many relationship in my database and I have these three tables: CUSTOMER_TABLE: Fields CUSTOMER_ID...
Back
Top Bottom