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!

Recent content by NewComer

  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

    Thanks so much for taking the time to help me. I really love this site !!!
  4. NewComer

    Summing Question

    Just another quick question, would the Nz function work in this situation? Thanks
  5. NewComer

    Summing Question

    Thank you Bill, will try it first thing Monday morning when i get to work and let you know how it goes...thanks again.
  6. 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...
  7. NewComer

    Storing the data with the Report

    Thank you Naith
  8. 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.
  9. NewComer

    Numbering Records

    dgillz, I'm using CR 8.5, sorry I forgot to mention that. I used your advice and it worked perfectly, thanks so much for your help.
  10. 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.
  11. NewComer

    Help with Crystal Report

    Thank you both so much. I did later realize that they must remain in the same order as the field list. So I suppose if I alter the view for the report it must go in the end of the view. Thanks again.
  12. 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...
  13. 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...
  14. NewComer

    NO DATA RETURNED IN A SELECT QUERY

    Right now in the "no data" property there is a message box that says there are no records for this aircraft, however, I want to replace that with a blub the says "no defects" in the discrepancy field.
  15. 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...
See more

Part and Inventory Search

Back
Top