Search results

  1. I

    Dlookup

    I have a table named frmNew with 3 fields; CustomerNo, Except and Status. The status can either be open or closed. I have a form named, frmNew with 3 text boxes of txtCusNo, Except. I want a vba code (preferrably, with Dlookup) that will look up the CustomerNo on the table anytime a customer...
  2. I

    How do I combine information from multiple rows without getting duplicate values in my report?

    I have a table (named: tblSales) with following fields: SalesAgent SalesMonth ProductCategory SalesAmount I have information like this: SalesMonth SalesAgent ProductCategory SalesAmount Jan A1 W1 5,000 Jun A1 W2...
Back
Top Bottom