Search results

  1. E

    Warning: Operation must be an updatable query

    Hey, Can anyone see the problem with this update query. This query is supposed to update Orders.CommissionID to a calculated maximum value from another table/query if the value of Orders.CommissionID is still its default value of 1. UPDATE CommissionGroupIDGroupMax INNER JOIN Orders ON...
  2. E

    Invoice ID expression

    Hey, I'm having a problem running an UPDATE query using an expression as the value to update to. I have 2 tables called "Invoices" and "Orders". Both "Invoices" and "Orders" have a field called InvoiceID with the primary key and foreign key respectively. I have a control "Create invoice"...
  3. E

    Lookup filed question?

    Hello, can someone please shed some light on something for me? I am having a lot of trouble understanding the workings of a particular lookup field in the template "Sales pipeling" (downloaded from Microsoft Office online (business), when creating a new db in Access 2007). In the...
Back
Top Bottom