Search results

  1. P

    Combo Box

    I have a combo box in a form that is used to populate one of the columns in a table. How do I get the description to appear in the table instead of the primary key?
  2. P

    Report Page Header

    I have a report that I would like the Page Header to appear in the following page if the data that goes with it continues to another page. Are there any settings or code that can accomplish this?
  3. P

    Append Query - Only new Records

    How can I modify the below code so that it only adds new records to AttributesTBL from ProductInformation-Consumer? Thx INSERT INTO AttributesTBL ( Material ) SELECT [ProductInformation-Consumer].Material FROM AttributesTBL INNER JOIN [ProductInformation-Consumer] ON AttributesTBL.Material...
  4. P

    Macros and Combo Box

    I would like to have a macro run when I click off of a combo box. The combo box has dates by Quarter and the macro refreshes a pivot table. The pivot table is filtered by the combo box quarter selection.
  5. P

    Query to Flag Database Changes

    I need to build a Query that will look at a previous table and a new table and flag any changes...what is the best way to go about something like this?
  6. P

    MAX Query

    I am looking for a query that will single out a SKU with the maximum number of sales. I have a table that shows a SKU's material code, sales and SKU number. What I need the query to do is find the MAX sales, (1831 in the below instance) and return only the line with 0CXX2005300CP. Material...
Back
Top Bottom