Recent content by Freefall27

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.