Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tcolebu

    query the top 100 records

    I have a "revenue field" in a table of several hundred records. How can I query only the top 100?
  2. tcolebu

    Access screen is totally blank - please advise

    For some odd reason, my access screen is totally grey, other than the tool bar at the top. It looks like all of my tables, queries, etc. . . are gone. But, my file size is 20 MB so I know this is not the case. I have tried about every command I can (on the file bar) and cannot seemt to make...
  3. tcolebu

    Filtering a report

    I have created a 30 page report that basically lists employee data for about 20 different people that can be divided into different groups. How can I make the report so that it allows me to enter in the person's name or groups and then run the report for that group onle? Thanks.
  4. tcolebu

    Division by zero

    I have a large query with a handful of "#error" cells because I am trying to divide by ZERO. This causes a problem in my report. Is there any property that I can change so that it is set to a NULL or ZERO (or something similar to that). Thanks.
  5. tcolebu

    Color Coding in a report

    I have a relatively simple report with no calulcations - just a trend of percentages that are being pulled directly from a table (VERY SIMPLE!). For anything that is < 80%, I want yellow (the background color), 90%<x<80% should be pink, and > 90% should be left alone. Is there a simple way to...

Part and Inventory Search

Back
Top