Search results

  1. V

    Sample Databases / Templates

    Some time ago I remember seeing a link to a site where a member had posted sample data schemes, relationships and templates for various types of databases. What was the link? Thanks, vetter
  2. V

    What Type of Query do I Need?

    I have 2 tables that have sales data, one for 2002, one for 2003. I would like to combine them to have all the data in one table. The format needs to be like: Cust, Item, 2002, 2003. If I have a cust, item that was purchased in both 2002, and 2003 will this show up in the same row? If the...
  3. V

    Employee/Supervisor Relationship

    I've in the past seen a helpful article on how to take an employee/ supervisor table to create an employee hierarchy. It would start with an employee lookup on their supervisor and so on until it reached the top. I believe that it was done by simply adding the same table in the query multiple...
  4. V

    Knowledge Base (KB) articles for download

    In the past Microsoft has made all the knowledge base articles for a particular release of Access available as a download file. Does anyone know if they have an updated version for Access 2000 or XP? I've only been able to locate the 97 version. Thanks, Vetter
  5. V

    Exclude Top 10 (Create "Other" Category")

    I am creating a report and have a query that is sorted on dollars and pull out the top 10 dollar amounts. Now what I want to do is get all the other items and sum them up to get an "other" category. I'm able to do this currently by creating an unmatched query using the query wizard between my...
Back
Top Bottom