Search results for query: *

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

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

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

I am using an MS Access 2k ADP (Converted into ADE) front end and SQL 2K on the backend. Although I taught pretty much myself into these concept with the help of some publications and users group posts, some time I would like to seek some specific help from fellow members. Now my organization...

I am using an MS Access 2k ADP (Converted into ADE) front end and SQL 2K on the backend. Although I taught pretty much myself into these concept with the help of some publications and users group posts, some time I would like to seek some specific help from fellow members. Now my organization...

I am using an Access 2k ADP (Converted into ADE) front end and SQL 2K on the backend. Although I taught pretty much myself into these concept with the help of some publications and users group posts, some time I would like to seek some specific help from fellow members. My Question is: Is there...

I am using an Access 2k ADP (Converted into ADE) front end and SQL 2K on the backend. Although I taught pretty much myself into these concept with the help of some publications and users group posts, some time I would like to seek some specific help from fellow members. My Question is: Is there...

I am using MS Access ADP front end and SQL in Back end. I have a form that is bounded to a Table with 20,000 records. That form has a list box in form Header Section where users select the record and it displays in Detail Section. The forms Navigation Button Property is set to "Yes". My...

I have a multi select list box (Row source is a table with 3 fields i.e. Unique ID, Last and First Name) and a Text box. The Users will select items from the List box and it will populate the Text Box. and Vice Versa. I need to be able to do the following. 1. Allow users to select single item...