Search results for query: *

I am using Access 2007 on windows 7 and need assistance with rearranging a file to match other file imports. Currently pull file # 1 down from vendor product in .csv format. File # 1 NO HEADER IN FILE RECEIVED RPDG Landmark Partners Richmond VA 10.1 10.2 10.3 10.4 10.5...

I am running Access 2007 and need to provide a report based on query below. I have customers from the same area that are assigned to certain equipment. I need to build a report which groups the assigned equipment, counts customers (assigned to equipment), and provides overall total. I have...

I have seperate CSV files (one for each loaction) that are generated from a system. I need to take the CSV output from each and combine into one query and sum the rseults. I am using Access 2003 and have the CSV files imported at this time. I have 11 total spreadsheets which have about 60...

Working in Access 2000 and experiencing a calculation issue when running query. Quantity: [Field]/9.2 - 9.2 used as a billing rate IntQuantity: Int([Quantity]) Whole Quantity: [quantity]-[intquantity] If I remove the /9.2 the calculation is correct. When using the /9.2 it gives the wrong...

I have 2 tables that need to be linked in Access 2000 and having some challenges. I need to link these and show all info on one line Table A (Two fields A & Z) ID SPC A = 12120 ID SPC Z = 10541 Link both fields above (ID SPC A) & (ID SPC Z) to (LOC ID) field below and show location. Table B...

I am using Crystal XI and getting data through an ODBC connection to Oracle DB. This is the SQL equivalent in Access of what I want to do in Crystal. select circ_path_hum_id, status, bandwidth, A_side_site_name, Z_side_site_name, ELEM_COST from path_view where circ_path_inst_id not in (...

I am receiving a script error when I open CR XI and am not sure how to investigate. The error reads as follows: Script Error Line 294 Position 58 'MsgBox "RegValue="&GetRegValue & "key= "&sregke Can anyone point me in the right direction? I am not sure how to view the actual script that...

I am having a challenge eliminating null values and others in a formula I am using CR XI and pulling data by ODBC from Oracle DB WO_NAME DESCRIPTION ACTUAL COMPL PROJECT ID SO_11351 CONNECT 10/1/2006 05-2006 SO_11500 CONNECT 10/6/2006 13-00000...

This is probably a fundamental question but I have not seen SQL written in this format before. I recieved these SQL instructions to run a report in the future from a consultant. Can someone help me determine what it means? I am not sure of the signifigance of the s. e. c. ?? not all the...

I am building an Access 2000 report and need to show a grouping of records. The records come from a join of three tables. I am trying to isolate certain records that do not appear in the table. Example: Table – Segment Attributes Name Category Vendor Status...

I am using Crystal XI and pulling data by ODBC connection to Oracle DB. I have a report which displays records that need to be combined on one line. Current Data Output: Work Order Task Status Ready Time WO1846 Billing Complete 8/31/06 10:58:56 A.M WO1846...

I am using CR 11 and pulling data by ODBC connection from an Oracle DB. I have been asked to write a report and think that a crosstab is the way to go but not positive. I am not sure if this can be accomplished using Crystal? The data is all pulled from one table in the following format: ID...

I am linking Oracle Tables into Access with ODBC driver and have a question about table merging. The Oracle Database contains tables with records which are in a production environment (Current) and tables that contain records that have been archived (old). I need to determine the best method...

I am using Crystal XI and pulling my data using ODBC driver from an oracle db. I am currently trying to compile a report that shows capacity of elements. The challenge is that I can't get the report to summarize correctly. Current report progression Site Name Category (Breakout of Site...

I'm looking for a form I can use within the IT department for end-users to request Crystal Report development and modifications. I could build one from scratch but I thought I'd ask if anyone had a developed form or knew of some good web sites to access templates. Thanks

I am running CR XI and pulling my data from an oracle db. I have a report that pulls work orders with all tasks associated with the order. Every time a user goes in and makes any kind of update to that task a new ready time is generated. I want to only show the earliest occurrence of each work...

I am running CR XI and need to filter records based on yesterday's date. I constructed formula CurrentDate - 1 and now need to only pull records with due date of yesterday. Name Number Ref Due Date Record 1 5679 11/25/2005 Record 2 6894 11/27/2005 Record 3...

I am running CR XI and pulling data by Oracle ODBC and am relatively new to the report writer. Here is what I am trying to accomplish: I have a report that consists of 6 subreports that show detail of six different stages of orders based on select expert criteria. Each report list the following...

I am running CR XI and we are in the process of implementing a new software package from which I am pulling data by Oracle ODBC driver. I just started using CR so this question may be fundamental in nature. We currently have a test database that I have been pulling data from and all my reports...

I am running CR XI and pulling my data by ODBC driver from an Oracle database. I have a report which pulls information on work order tasks which need to be completed. Each time a rep goes in and enters a new task another date and time stamp is placed on a new record. I need to only display the...