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!

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

Recent content by comprt

  1. comprt

    #Num! error eliminiation

    Hi, I would like the value of my percentage calculation to display 0%, instead of #Num!, in my report. I'm sure there is an easy solution, but the web seems dearth of them. Thanks for your help. Azal
  2. comprt

    Multiple, aligned queries in Report

    Hi, I am relatively new to advanced functionality within Access. I'm stuck with Access 97 as well. I am having some different issues presenting my data within a report. I wanted to know if anyone can help me with the following issues...I'd really appreciate it: ----- 1)How can I align my...
  3. comprt

    Counting Records

    I'll try that if this doesn't work out, but actually I've tried the UNION ALL statement to bridge a bunch of SQL SELECT statements together. The problem is how would I uniquely access them from a record (normally I would use a variable name)? If there isn't an easy way, then I'll try writing...
  4. comprt

    Counting Records

    Thanks Jeremy. This helps quite a bit. However, I'm wondering if there is a way to do this without necessarily creating a new query object for each one of these totals (I have about 120). I would ideally like to assemble them into the same object, if possible. Do let me know, and thanks very...
  5. comprt

    Counting Records

    Hi, I would like to know how I can develop a new table containing total number of records from some of my other queries. I have a few different queries, and I would like to tabulate simply the total number of records in each of these queries into a table. Additionally, I would like to know...
See more

Part and Inventory Search

Back
Top