Search results for query: *

I have a field that I need to remove a certain range of numbers from, however, this field is VARCHAR2 and can contain letters. My current code is as follows (in the Where clause): field.field_name not between '27000000' and '27999999' The problem is this is also taking out records that are not...

Hello, I have a field that I need to remove a certain range of numbers from, however, this field is VARCHAR2 and can contain letters. My current code is as follows (in the Where clause): field.field_name not between '27000000' and '27999999' The problem is this is also taking out records that...

I am trying to use an Excel table as an ODBC connection but I am having trouble adding the datasource in Crystal and I am getting an error saying "Logon Failed, Details: HY000 The Microsoft Jet database enginer cannot open the file '(unknown)'. It is already opened exclusively by another user...

I have a report where I need to include the first two records that appear in the detail section, in the group header. I know that the first record of the detail section will be shown if placed in the group header, however I am looking for an easy way to have this record and the very next one...

Hello, I am creating a report that pulls in products that are forecasted by our customers. The way my report works is the user inputs an end date, and the report goes out and pulls in all of the products that are forecasted up to that date. On my report I display Part Number, Part...

I am looking to make a pie chart that shows workload percentage by task, and if all the available time is not being allocated to these 4 specific tasks, I want the remaining portion of my pie chart to display an "unused time" percentage. I currently have my pie chart breaking down each task but...