Search results

  1. K

    Multiple Price Columns

    I am using Access 2003. I am trying to create a pricing utility for a cabinetry line. I have 158 products that all have 8 different price groups depending upon the door style the user selects. I am at a loss as how to structure the tables. Once the user selects the door style and looks up...
  2. K

    More Query Fun!!!

    I have a query with the following fields: Category >> Date >> Description >> Amount There are only 4 possible choices for Category which I defined using a lookup. These categories are "Improvements", "Maintenance", "Operating Cost" and "Startup Cost". I have a form with 2 checkboxes. If...
  3. K

    Return Both Yes/No Records In Query

    I am trying to create a form based on a query that has a yes/no field. If the user checks a box on the form it will return all the records regardless of whether they are "true" or "false". If the box goes unchecked only the "true" records get returned. I have tried the following and many more...
Back
Top Bottom