Search results for query: *

Thanks SQLSister, Within the DTS package I set up a transform-data task to extract the data I need to populate a table within SQL 2000. The task mirrors the query contained within the config file. I've attempted to set up input paramenters within the DTS package to point to the fields of the...

Hi everyone, Below is a stored procedure referenced within a config file as part of an executable running within a SQL job. My goal is to create a DTS package and remove the dependance of the executable within the job, but I'm unsuccessful in setting the parameters to point to data the...

Good morning everyone, I have an "Order" table that has the following for data: Ord# Part# Zone 1 1 A 1 2 B 1 3 C My goal is to create a separate table that reads the data from the "Order" table and produces the following: Ord# Zone...

Good afternoon! I'm working on a database that is being used to cross reference pricing information on our products versus our competitors. In short, one table of our parts, one table of our competitors parts and a third table that houses a cross reference from our part to their part. I'm...

Hi Roy, I added the spaces at the end of the concatenated text, then modifided the =" * " to ='*' and the query executed. The "*" is actually the text in the field indicating a particular record type. Have a star!

Good afternoon everyone, I'm struggling with the following snippet of code. All goes well until the RunSQL line. At that point, I receive the Run-time error '13' Type mismatch message. The query is to make a new table from linked tables from an AS400. I'm using Access 2000. I can get the query...

Thanks much. I like the piece of code prompting the user regarding files that exist. I'm still having a problem with the actual data being exported. Separate files are created, which is good, but all data is being exported to each of the files regardless of the rst!TYPE. Am I missing a filter...

Greetings everyone, I'm submitting a piece of code for your review. Here's what I'm trying to do. I have a dB set up to export data from a table to a text file used for printing calling cards. One of our clients has multilpe cards that we fulfill. I'd like to be able to export separate text...

Greetings everyone, I'm submitting a piece of code for your review. Here's what I'm trying to do. I have a dB set up to export data from a table to a text file used for printing calling cards. One of our clients has multilpe cards that we fulfill. I'd like to be able to export separate text...

Greetings everyone, I'm submitting a piece of code for your review. Here's what I'm trying to do. I have a dB set up to export data from a table to a text file used for printing calling cards. One of our clients has multilpe cards that we fulfill. I'd like to be able to export separate text...

Greetings everyone, I'm submitting a piece of code for your review. Here's what I'm trying to do. I have a dB set up to export data from a table to a text file used for printing calling cards. One of our clients has multilpe cards that we fulfill. I'd like to be able to export separate text...

Hi Jerry, Thanks for your reply! I'm trying to take the data and eventually export to a text file used for printing. We print calling cards and if a customer requests two (or more) of the same card, I need to have two (or more) rows of data for the same person in order to print from our...

Thank you very much! The entire data set duplicates to from the OrderProduct table to the CCIN table. One problem, if the OrderProduct!Card_Qty value is "2", there should be two rows of the same record in the CCIN table. In essence, the number of rows of data in CCIN should be the...

I have the following piece of code behind a command button within a sub. My goal is to examine a record from the OrderProduct table and, pending the value in the Card_Qty field, duplicate the record in the CCIN table based on the OrderProduct!Card_Qty value. The problems is I'm only getting the...

I have the following piece of code behind a command button within a sub. My goal is to examine a record from the OrderProduct table and, pending the value in the Card_Qty field, duplicate the record in the CCIN table based on the OrderProduct!Card_Qty value. The problems is I'm only getting the...

I have the following piece of code behind a command button within a sub. My goal is to examine a record from the OrderProduct table and, pending the value in the Card_Qty field, duplicate the record in the CCIN table based on the OrderProduct!Card_Qty value. The problems is I'm only getting the...