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 IamaSherpa 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. PerryP38

    Exchange across seperate forests help

    Can anyone tell me if excahge server in one forest can support email for a second seperate forest. The only exchange server will be in the first forest.
  2. PerryP38

    Query Update Help

    I have 800 records with a socila security number. The person who designed the table made this a text field and included the dash character as part of the data. I would like to change this field to a number field and eliminate the dash. ie go from a ###-##-#### to a ######### Any suggestions...
  3. PerryP38

    Help with limiting records to be counted

    I did have them as part of the formula in the detail section. I have removed them and put them in the footer section now. They are not commented out that was my mistake in the post. When I run the report I am now getting a group for each complain and then a list of dates with zeros or numbers...
  4. PerryP38

    Help with limiting records to be counted

    Well I thought I had it, and I seem to be getting closer. I created a formula box with this formula in it and placed it in the group header which was based on the complaint number. WhilePrintingRecords NumberVAR MTDComplaints:=0; NumberVAR YTDComplaints:=0; NumberVAR LYTDComplaints:=0; //end...
  5. PerryP38

    Help with limiting records to be counted

    Thank You very much for your help.
  6. PerryP38

    Help with limiting records to be counted

    The information I want to count is in one table.  The fileds I am looking to use for the report would be a date field indicating the date the complaint was received and a text or string field with the descrption of the complant type.  The complaint description or type would...
  7. PerryP38

    Help with limiting records to be counted

    Yes, I know how the database is configured.  I designed the tables.
  8. PerryP38

    Help with limiting records to be counted

    I would like to design a monthly statistical report that counts the types of complaint we receive and have a field next to it that shows the number of complaint for that same category for last year, and then show a percentage difference.&nbsp;&nbsp;Some thing like this:<br><br>Type of...

Part and Inventory Search

Back
Top