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 MikeeOK 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: peterpater
  • Content: Threads
  • Order by date
  1. peterpater

    #Error - Clean up

    Hi there: Is there a function in Access where I can write a query to check for Errors in a field and clean up the data, as I am importing the file from excel. For eg: Excel has ISERROR. Thanks.
  2. peterpater

    Sum in a group

    Hi: I have a table with the following fields: -EmpID -Date -Event (Project) -TimeSpentInEvent (in sec) I am trying to write a query which will give me a sum of TimeSpentInEvent for an event for a day per Employee. (For eg: John may be in a Project from 11am-12pm and 3pm-4pm on Aug 3rd). So the...
  3. peterpater

    Count Formula

    Hi: I have a Flag field which is either "Y" or "N". The other fields are: - Date - Category - Topic - Flag ( Y or N) Group 1 is Date, Group 2 is Category and Group 3 is Topic. I am trying to count the number of Ys in a Category but I am unable to do so as I am getting errors. Any suggestions...
  4. peterpater

    Accumulative Count

    Crystal Version : XI Tables : - Employee Table (Emp_Name, Manager Name) - Sales Table (InvoiceNum, Date, NumberofSales, ProductType). This table contains data for the whole year. Problem: For the month of AUGUST (ONLY) we are running this new promotion for our tiny sales department. -...
  5. peterpater

    Accumulative Count

    Crystal Version : XI Tables : - Employee Table (Emp_Name, Manager Name) - Sales Table (InvoiceNum, Date, NumberofSales, ProductType). This table contains data for the whole year. Problem: For the month of AUGUST (ONLY) we are running this new promotion for our tiny sales department. -...
  6. peterpater

    Month and Year Extraction

    Crystal Version :11.0 Database : Access 2000 Hello all: I need to extract only the month and year from a date in my Access table which is formatted as 04/19/06 i.e mm/dd/yy. I only require to extract the Month and the Year so I can group them accordingly. I tried using the formula below...

Part and Inventory Search

Back
Top