Search results for query: *

Experts- I need some code that will search all tables/fields in a schema for a specific value. The db is relatively small so this isn't a huge issue. Not being very conversant with pl/sql, I cannot get the code I have found elsewhere on the net to work. Thanks in advance for your help.

Hello- I have a query that produces 9 columns, I would like to do a subtotal on the 9th column based on 2 of the returned columns. I cannot get this to work with ROLLUP. Is it even possible? Thank you!!

Hello- I need to create a report in Crystal with an Oracle back-end and a query that uses unbound variables (:Beg_Date) and (:End_Date). When trying to do this I get the "ORA-01008: not all variables bound" error. Unfortunately I do not have ANY development rights in Oracle - I can only...

Hello Long story short: 1) I pull field EXPORT_DATE (format DATE) from table TABLE1 which yields '9/10/2011 7:35:10 PM' 2) I need to take this value and plug it into the WHERE clause of another query, but Oracle expects this format: 'DD-MON-YY'. 3) I need to retain the timestamp How do I...

Hello I am trying to do the following via SSIS: 1)Extract data from SQL Server 2)Put this data into a recordset 3)Update the recordset (e.g. if column 1 has value "tomorrow" update it to say "today") 4)Export to Excel I am not having trouble with any of this except #3. Not sure how to update...

Hi- I have a report with a/r data that includes account, invoice #, transaction type, transaction amount, and check #. Every account has multiple invoices, each invoice can have multiple transactions (of different or the same type), and each transaction which is a payment may have a unique...

Hello I am performing a pricing validation based on data in a table and based on this validation will update a comment field in the same table. The sample data might be: Field1 Field2 Comment $10 $5 "Field1 should be $8 - Field 2 should be $3" To do this, I wanted to basically build...

Hello-- I have a db that imports a customer file, formats, and exports a new file for upload into a different system. I need to validate whether or not there are any null values in any of the fields after importing, as even one null value throws everything off. Any ideas how to go about this...

Hello - I have a somewhat complex Oracle query (complex because lots of nested case statements) that runs fine out of Oracle. However, when trying to get this to work in an Access Pass Through, it throws the error "Pass through query with ReturnsRecords property set to true did not return any...

Hello - I have a matrix report which sums accounts receivable by month/year as column and bucket(1-30 days, over 90 days etc) as rows. What I need to do is create monthly, quarterly and yearly delta calculations at the end of the report, i.e. as columns to the right of the most recent...

Hello- I am using VBA to put strings together, insert into a table and then export to .txt for upload by a different business system. The problem is the other system can only handle line feeds, whereas it seems as though Access puts carriage returns at the end of a string. I tried to solve...

Hello - I have a bit of a dilemma here. I have to generate a fixed-width text file that follows this pattern: Header Record Invoice Header Record Line Records Trailer Record Now the problem is that the fields in the different records are obviously not the same, and the spacing between...

Hello - I have a table with field "Invoice" set to data type text. The corresponding field "Invoice" in the Excel file to be imported has data that follows the following pattern: Either 1) 1234567 Or 2) 1234H567-0 Now, if the data in the Excel file is sorted such that the numeric values in...

Hello - I have a few Pivot Reports in Excel where all data is put into the "rows" area. This results in the following sort of grouping hierarchy: CUSTOMER # -> INVOICE # (all invoices for that customer #) -> ACCOUNTING DATE (for all transactions per invoice) -> TRANSACTION DESCRIPTION ->...

Hello-- I am getting the "method or data member not found" error on .[BLAH] with the code below. All table, field, etc names exist and are spelled correctly. I just used the same code in a different table without error. Any idea what the problem is??? Sub TEST() Dim DBS As Database Dim...

Hello- I need to import a CSV file that has Invoice and Line Detail data in the same fields, and then create a delimited text file in which the Invoice and Line detail fields have different spacing. CSV file Example (Invoice and Line data is in same fields though does not appear as such in...

Hello-- I would like to parse a string based on the number of characters before and after multiple occurances of a hyphen. A sample string is: 123456-1-12345-0 The number of characters in each portion of this string (between the hyphens) may vary. I need to be able to basically seperate...

Hello-- When exporting a large table that contains Invoice and Line Detail records to text file, Access is inserting a blank row between each line. What can be done to avoid this? Thank you!!

Hello - I have a pivot table in Excel that I am trying to mimic in Crystal. Basically, the columns are months, the rows are product, and the summarized value is revenue. The "Page Field" is customer...so the end user can filter the pivot table by customer. Is there any way to do this in...

Hello- I have a simple bit of code to import text files using the CreateObject(scripting.filesystemobject) etc method. I use it in many different apps without problem. Anyway, in the latest app I can sometimes import the text files and sometimes not. When I can't, I get the "The Microsoft...