Recent content by patiya

Thanks George

Hellow there, I have a SQL 2005 Table with 2 Columns: Column Name: Data Type: PERIOD_END_DATE Nvarchar(50) Date_Period_End Datetime ___________________________________________________________ Currently Data in Column's: PERIOD_END_DATE...

Hellow Folks. Here is the Original Data in my single SQL 2005 Table (Common Column is Department# in rows): Department: Sells: 1 Meat 1 Rice 1 Orange 2 Orange 2 Apple 3 Pears The Data I am expecting separated by Semi-colon: Department: Sells: 1...

Hi Everyone. I am using NorthWind as an Example: Parent Table derived from: Categories. I added a new Column E-Mail and Selecting rows where Category Id <=3. Here is my Data. Category ID Category Name Category E-mail 1 Beverages Beverages.com 2 Condiments Condiments.com 3 Confections...

Hi Everyone. I am using NorthWind as an Example: Parent Table derived from: Categories. I added a new Column E-Mail and Selecting rows where Category Id <=3. Here is my Data. Category ID Category Name Category E-mail 1 Beverages Beverages.com 2 Condiments Condiments.com 3...

Folks, I am using ADP (2K) from end, SQL back end. I am having a weird problem. I have a DTS Package that imports EXCEL data from Local Drive to a SQL Temporary File. 1) When I Execute the Package from the EnterPrise Manager, it always Works. 2) But when I start my ADP program (Below is...

Folks, I am using ADP (2K) from end, SQL back end. I am having a weird problem. I have a DTS Package that imports EXCEL data from Local Drive to a SQL Temporary File. 1) When I Execute the Package from the EnterPrise Manager, it always Works. 2) But when I start my ADP program (Below is...

Thanks Fancy and Bisman, Bisman, I like the Idea that you mentioned in #2. I think it is more flexible. But I only know how to create Custom Menu Bars using Access Tutorial. I do not know how to create Navigation controls or Create Menu bars in Form. If you have some tutorial or sample...

Hi there, I am designing a new Access 2003 database, hoping to migrate into ADP in the near future. I would like to create separate menu items like Access (such as File, Edit, View etc). And each of the menu items will have drop down menu pads (Ex. File Menu items have: New, Open etc). What I...

Hi there, I am designing a new Access 2003 database, hoping to migrate into ADP in the near future. I would like to create separate menu items like Access (such as File, Edit, View etc). And each of the menu items will have drop down menu pads (Ex. File Menu items have: New, Open etc). What I...

Thanks Nevermoor (Programmer) for your help. But If I need to return more fields such as employee Id, the grouping seems not working.

I am using ADP front end and SQL on the back end. I want to run a report based on these 2 tables. Table1 Data: Client Id Date Employee ID Record Source 23376 1/9/2004 128 Table1 23376 1/8/2004 30 Table1 23379 1/6/2004 15 Table1 23377 1/6/2004...

ADP/SQL Report Selection Criteria I am using ADP front end and SQL on the back end. I want to run a report based on these 2 tables. Table1 Data: Client Id Date Employee ID Record Source 23376 1/9/2004 128 Table1 23376 1/8/2004 30 Table1 23379 1/6/2004 15...

I am using ADP front end and SQL on the back end. I want to run a report based on these 2 tables. Table1 Data: Client Id Date Employee ID Record Source 23376 1/9/2004 128 Table1 23376 1/8/2004 30 Table1 23379 1/6/2004 15 Table1 23377...

Thanks Omega36. Thanks for your help and suggestions. Appreciate