Search results

  1. T

    Count for two different possible values in the same field

    I'm trying to make a report that shows three fields: Date, Company, and Track. The 'track' field can only have two values, sales or technical. In this report I need to show for each month, and for each company, how many records exist for sales, and how many exist for technical. So far, I...
  2. T

    Append Query Question

    I'm working on this inventory database. So I have a select query called "trigger query" that lets me know what items need to be orderd. Then I have an append query that adds those items to a table called ORDERS. From the trigger query, I have the fields Item Number (which is a primary key in...
Back
Top Bottom