I have a DB of parts requiring machining and a DB of machine shops that can do at least one of the machining operations. I want to select a part, then the...

I have a report that has to do the following take total number of hours for a given worker on a given day send this through a whole bunch of rules to churn...

Hi there, I have a query that pulls information on contracts that run in annual cycles. Each record for each contract has a "renewal_date" and based on this...

Hello and thanks in advance for answering my question! I am working on a query involving 3 seperate fields. What I want to do, is to be able to use...

I am rewriting a lot of old web pages that used dynamic SQL in the code of the page and converting them to use stored procedures in the database instead. I...

Hi All, I have data that is coming from an external source. I have to strip out a number out of a text field. However I need to then link this number to...

In my table I have a field that calculates when any given record was created. I did this by setting the defalut value to "now()". I changed the format so...

I have 2 columns of data, Date Column (short date) (from 10/2/02 to 9/30/05) & 2nd column of say 26 categories (A,B,C,...Z). Total records 500,000. I need...

I'm brain dead at the moment! I need to count the number of days that have an entry in my data. Some days may have multiple entries so if I pull a count I...

I have a table with an item field that can consist of an item #, a sub assembly item #, and sub-sub assembly item # separated by periods. I need to break...

Is there a way to calculate group totals in a query. I want to sum up the value of several items per box #. -- Lynette

Hello - I have extracted a number from a string and would like to sort on this value as if it were a number. In my query I have created a field as...

I really need someone’s help. I have two tables, one has employee’s allowances and the other has their basic pay. I need to calculate their gross. The...

I posted this yesterday , got one post for additional infor, posted update, and then nothing. I would like to try again since I really do need to get this...

Hi, i have to insert values into two tables in one transaction. The first table (base table) has a primary key (type 'integer') which is incremented...

I need a query that will give me a value of 1 for each record that is not null in any one of twenty fields (text datatype). In other words, I need to search...

Hi, I have a table with two columns where the value may have changed and may not have changed - for example Group 5 to Group 10. I want to query so that I...

Due to the new format of the input text file, I modified the import specification of my tool. I basically deleted a column named RECORD. Thus, the new import...

I want to group data so that I can see the total risk applicable to a merchant ID and name of merchant. The names of the same merchant are recorded in...

When I was making a simple query I´ve got this message "internal OLE automation error" and I don't know why. Can anyone help me please? Thanks