Search results for query: *

Thanks, it helped!

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.

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

Thanks a lot folks. It works.

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

Max Gift Certificate means the max number of gift certificate allocated for one category. Therefore, if the sales team is of 100 people, only the first 10 to reach category 1 criteria will recieve the category 1 gift certificate (which happens to be $50). SalesCountPerDay is a summary of how...

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

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

Thanks it worked. It was simple. I guess I am a newbie!

How would I manipulate the date (mm/dd/yy) just so that I can extract only the Month-Year and group it?

How would I format the field so that I can group it by the Month-Year only. If I directly change the format in the field, it gets grouped by dates. I want to group them by Month-Year. Thanks in advance.

Thanks!

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