Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Freefall27

    Converting file into new format

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

    Converting file into new format

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

    Converting file into new format

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

    Converting file into new format

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

    Group and Count based on Field Population

    Works just as required. Thank You!
  6. Freefall27

    Group and Count based on Field Population

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

    Group and Count based on Field Population

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

    Merging csv data to produce query

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

    formula challenge

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

    Access table relationship linking

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

    Query Filters

    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 (...
  12. Freefall27

    Script Error when opening CR XI

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

    Formula to eliminate values including nulls

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

    Formula to eliminate values including nulls

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

    Formula to eliminate values including nulls

    Kendel....Thanks for your help.
  16. Freefall27

    Formula to eliminate values including nulls

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

    Formula to eliminate values including nulls

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

    Formula to eliminate values including nulls

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

    EQL Format Question

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

    EQL Format Question

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

Part and Inventory Search

Back
Top