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 gkittelson 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: *

  • Users: Kobs
  • Order by date
  1. Kobs

    Difficulties in Printing (Access report) with HP Deskjet

    A collegue has been having trouble printing an Access database I recently created. I have Access 2000 (SP-3) and Windows 2000 Professional. I had no troubles printing off my HP 935C. However, when I sent the file to a collegue they had difficulties printing. They are using Access 2000...
  2. Kobs

    Displaying Only One Record in a Report

    I am running a report that essentially is serving as a counter. I have 100 records and I am running a counter that will tell the user 1) the total number of records, 2) the total number of records that meet a certain condition, and 3) the total number of records that do not meet the condition...
  3. Kobs

    Problem with DCount in Query

    I tried putting the function in the report like you suggested. However when I tried =DCount(&quot;[Certify Exp Date]&quot;,&quot;AVL&quot;,&quot;[Certify Exp Date]=&quot;&quot;&quot;) or =DCount(&quot;[Certify Exp Date]&quot;,&quot;AVL&quot;,&quot;[Certify Exp Date]=<>&quot;) I received...
  4. Kobs

    Problem with DCount in Query

    Kevin, The table itself has about 50 fields overall with text fields (such as company name, address, etc), numerical fields (statistics such as accuracy rating, errors, receipts), and a few date/time fields (date survey was sent, and the afformentioned Certify Exp Date).... I have run numerous...
  5. Kobs

    Problem with DCount in Query

    I have an Access Table, entitled AVL. One of the Field Names/Columns is Certify Exp Date. In this column, my records either contain a date or are left empty/null. In my query, I want to count the number of records that have a date in that field and another count of the number of records that...

Part and Inventory Search

Back
Top