Search results for query: *

Yes, the vendor product has an export utility to save the file in various formats. I save to hard drive in .csv and that file is linked in database. File #2 is how the data needs to be rearranged in file #1. The master file is in file #2 format and essentially would be the same other than the...

didn't copy correctly Location Network RPDG Landmark Partners Richmond VA - 10.1 (2 fields)

My apologies I should have separated better. NO HEADER IN FILE RECEIVED RPDG Landmark Partners Richmond VA - 10.1 - 10.2 - 10.3- 10.4 - 10.5 (6 fields here but there will be many more in some areas ...10.6 -> 10.50...etc The master file is in format below and updated internally on a daily...

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...

Works just as required. Thank You!

dhookom that works perfectly! One additional issue that I need to account for is when the assigned equipment is blank. I will need to incorporate this into the SQL statement. YYYYMM, Area, Customer, Total, Assigned Equipment, 201204, A Town, Joe Smith , 200, ABC, 201204, A Town, Bill Davis...

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...

How do I set this up if I only have ACTUAL COMPLETE DATE on Report? Newer to Crystal and trying to learn as I go here. Thanks

This report is working great now. I have one more question that hopefully someone can help me with on the report. I need to only select the previous whole week and run the report and distribute. I have put LASTFULLWEEK into the select expert which pulls desired records. Is there a way to take...

Kendel....Thanks for your help.

Kendel.....I used your formula and it eliminates all null values but still shows 05-02006 & 1300000 Thanks

BobSuruncle, I entered the following in my report: {WORK_ORDER_INST.ACTUAL_COMPL} in MonthToDate and ( NOT IsNull({WORK_ORDER_INST.PROJECT_ID}) ) OR ( NOT ({WORK_ORDER_INST.PROJECT_ID} in ['05-02006','13-00000']) The nulls have been eliminated from the report but I now get data from September...

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...

Lespaul....Thank You for the help. It all makes sense now. I'll determine the process of adding the additional fields. They should be contained in one of those tables. Perhaps the original query must be done to group the records and then add the other two fields on at the end. The database right...

THis should be SQL in the title.....hit the button to quick.