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 schumarg

  1. schumarg

    PDW Wizard - Errors on install

    Hi, I've created my first program that I would like to install on different computers. All have W95 OS's. I'm using VB6 Pro on a computer that has NT 4.00 OS. The program needs to access to 4 different Access db's. All on a Novell Server, our G: drive. I've run the PDW Wizard and it will...
  2. schumarg

    Count records in detail footer section

    Thank you!! Working great now. Bob s-)
  3. schumarg

    Count records in detail footer section

    Hi, Tried that one, however it returns a count of all records with an amount of $0.00 for the entire report. I used this for the cover sheet, but would like to show the count within the footer section for each group. Thanks, Bob
  4. schumarg

    Count records in detail footer section

    Hi, Trying to count and show the records in a detail footer section that have a dollar value of $0.00 in the detail section. Report is grouped by a joined field, but can't see where that should matter if I'm only trying to count records. Have tried the following but it returns the count of...
  5. schumarg

    DCount within GroupFooter

    JoaoTL Thanks for you assistance, but it seems I forgot a small bit of info. My appologies, the report was made some time ago and my memory is not as it should be. The report is Grouped on a Joined field that I did not mention and this is probably the problem. The table and field names are...
  6. schumarg

    DCount within GroupFooter

    JoaoTL Thanks for the reply. But.... Tried the following: SELECT RIHAUFK.AUFNR, Count(RIHAUFK.GKSTI) AS CountOfGKSTI FROM RIHAUFK GROUP BY RIHAUFK.AUFNR HAVING (((Count(RIHAUFK.GKSTI))=0)); I hope it's only syntax (which have given me alot of gray hair) because it is asking for a parameter...
  7. schumarg

    DCount within GroupFooter

    Hi, I'm trying to use DCount to count the records within a report Group with a value of $0.00 and show in a group footer textbox. The report is based on a query. I created:- =DCount(" [RIHAUFK]![AUFNR ]","RIHAUFK"," [RIHAUFK]![GKSTI ]=0")...
See more

Part and Inventory Search

Back
Top