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 Rhinorhino 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: *

  • Users: NewComer
  • Content: Threads
  • Order by date
  1. NewComer

    HELP WITH A QUERY......PLEASE !!!

    We collect maintenance data on aircraft. Each aircraft is assigned a serial number called BUNO. When receiving maintenance it goes through different phases, we refer to as 1 PMI, 2 PMI, 3 PMI and Baseline. The query I am developing only wants to look at BUNO's that have gone through maintenance...
  2. NewComer

    Line Charting Help

    I am using CR 8.5 and want to create a line chart ploting standard deviation of task manhours. I am having a terrible time trying to create this chart. I have 4 fields as follows: Location Phase Task Number Standard Deviation Manhours I want to group by location then phase. I want my x axis to...
  3. NewComer

    Summing Question

    Our database has a SQL backend and a Visual Basic Frontend for data entry. I often create reports via Microsoft Project. My question, in a query I am summing two integer fields, if their are no manhours for one of the fields it is left null. However, when I try to sum them it will not sum unless...
  4. NewComer

    Storing the data with the Report

    I am new the CR, am running CR 8.5. I have created a report that stores the data with the report which makes the report almost 1 meg. My question is can i store the report without storing the data with it and will query the database upon opening.
  5. NewComer

    Numbering Records

    I am creating a report and each record for that report is numbered starting with one. I used the special field "record count", however, I need it to start over every time their is a change in Aircraft. Could someone please tell me how to do this? Thanks so much.
  6. NewComer

    Help with Crystal Report

    Hi, I am brand new to Crytal Reporting. I have created a report via an ADO connection to the SQL Server. I clicked refresh to update the data and although my text fields in design view still read the same, the data displayed is from another field in the SQL view. It seemed to scramble my fields...
  7. NewComer

    Exporting From Access Form To Excel

    I currently have a form (Form1) with a subform (Form2). After entering criteria in Form1 the results set is displayed in datasheet view on Form2. I would like to create a button when pushed will open a new Excel workbook and then send the results set from Form2 to a worksheet. Any help with...
  8. NewComer

    NO DATA RETURNED IN A SELECT QUERY

    I have developed a report based off a select query, the user must enter an aircraft number at the prompt, my problem is I need the query to return a "no discrepancies" statement in the discrepancy field is no records are returned. Can this be done, if so was wondering how to do it...
  9. NewComer

    HELP WITH A QUERY

    I am creating a report based on a query of which I have enclosed the following SQL code. What I need to accomplish is if their are no records returned based on buno_no, it returns "No Discrepancies" in the discrepancy field. Thank you in advance for your help. SELECT...
  10. NewComer

    NEED HELP WITH "NO DATA" EVENT PLEASE

    I am developing a series of reports for maintenance on aircraft and if no maintenance has been performed for a particular aircraft the query will obviously return nothing. However, at the report level I need to display in one of my text fields (discrepancy), "No Discrepancies". If...
  11. NewComer

    CREATING AND RESETTING COUNTER ON A FORM

    What I was actually trying to do is find a way to return only the top 6 part numbers grouped by task number. It was suggested that I create a form with a counter that resets everytime the task number changes, running the entire table through this form. This would allow me to untilize this...
  12. NewComer

    Could Someone Please Help With This ???? Returning Top Values

    I am trying to create a query that returns only the top 6 part numbers per task number(ascending) and it associated quantity(desc). The only fields included in this query are the 3 stated above plus 1 more listed as follows: Task Part_No Quantity Nomenclature If anyone know how accomplish...
  13. NewComer

    <b>TOP 6 ON GROUP BY QUERY<b/>

    I am creating a query listing top 6 part numbers grouped by task number, ascending by task no and descending by quantity. I came across a prior thread and was trying to format to suit my needs with no luck. Was hoping someone could give me some insight. Thanks in advance SELECT a.Task...
  14. NewComer

    OPEN A DOCUMENT IN EXCEL FROM A BUTTON IN ACCESS

    MANY OF THE CHARTS I CREATE, I CREATE IN EXCEL USING AN ODBC LINK. WHAT I WOULD LIKE TO DO IS PLACE A BUTTON ON A FORM THAT WILL OPEN TO A SPECIFIC CHART IN EXCEL. IF SOMEONE COULD HELP ME WITH THIS I WOULD CERTAINLY APPRECIATE IT. THANKS IN ADVANCE.
  15. NewComer

    HELP WITH A QUERY

    Hi, I have a database that tracks maintenance on an aircraft using task numbers. Sometimes the maintenance on an aircraft changes from one task number to another. I have a field in a table that says whether the task is ACTIVE, RETIRED, or CHANGED. What I need to show is if a task is CHANGED, I...
  16. NewComer

    FORMATTING GRID IN A REPORT

    I AM DESPERATE FOR HELP WITH THIS PROBLEM, AM HOPING SOMEONE HAS THE ANSWER. MOST OF THE REPORTS I CREATE HAVE IN THE PAST BEEN EXPORTED TO EXCEL PRIMARILY BECAUSE THEY REQUIRE A GRID. THE REPORT I'M WORKING ON NOW HAS 6 COLUMNS, OF THOSE 6 COLUMNS TWO COLUMNS CONTAIN MULTIPLE LINES OF DATA...
  17. NewComer

    Need Help Creating Search Form

    I'm creating a search form. So far I've created a subform and placed it on the main form. What I want to do is for the user to be able to type in what they are searching for in a text box on the main form and as they begin to type the subform will display everything that contains those...
  18. NewComer

    WebSphere and Seagate Crystal report integration

    i want to know how to configure WebSphere App Server for crystal reports 8.5 (which has crystal report's web component server running on IBM http server). I want to run an .rpt file (containing a parameterized query for an oracle database) of seagate crystal report on ibm http server. what url...
  19. NewComer

    Configuring WebSphere App Server for crystal reports 8.5

    i want to know how to configure WebSphere App Server for crystal reports 8.5 (which has crystal report's web component server running on IBM http server). I want to run an .rpt file (containing a parameterized query for an oracle database) of seagate crystal report on ibm http server. what url...
  20. NewComer

    How to find my loosing file

    I have xls type file (Excel 97)when I opened ther was no data, and the format cells looks like a new file. Is it caused by virus or what? And how to get my file back?

Part and Inventory Search

Back
Top