User Profile

Collapse

Profile Sidebar

Collapse
owz
owz
Last Activity: Aug 4 '07, 05:12 PM
Joined: Nov 29 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • owz
    replied to load list of details, and display to screen.
    in Java
    sorry for double posting, i was tryin 2 edit the 1st post but i couldnt.
    yes i did read the link info.It not just loadin an display, it has 2 be stored sum how mabey an array so tha i can use a command line interface type thing to sort,add, delet,save an so forth 2 the data.
    See more | Go to post

      Leave a comment:

    • owz
      replied to load list of details, and display to screen.
      in Java
      Help needed with importing file an displaying

      This is what i have so far .Line 99 i have a missing return value, no idea what it should be.
      As stated above, i am loading a txt file in an tryin 2 display 2 the screen. also calculate a total value of all cars.


      Code:
       import java.io.*;

public class Garage 
{
  private static final int MAX_CARS = 10;
  private Car []
      ...
      See more | Go to post
      Last edited by owz; Jul 3 '07, 02:37 PM. Reason: added more code

        Leave a comment:

      • owz
        replied to load list of details, and display to screen.
        in Java
        The file is not just loaded an displayed .

        It is an order
        String Registration Number
        String Manufacturer
        String Model
        int Year
        int Price

        i plan on creating a command line interface to -

        Print Stock
        Add car
        Sell car
        Amend price
        Find car details
        See more | Go to post

          Leave a comment:

        • owz
          started a topic load list of details, and display to screen.
          in Java

          load list of details, and display to screen.

          I am trying 2 load details about cars from a.txt file

          and then display the total stock value off all cars.

          Code:
          public class Car 
{
  // attributes
  
  private String manufacturer;
  private String model;
  private String regNo;
  private int    year;
  private int    price;

  // constructor
  
  public Car(String newManufacturer, String
          ...
          See more | Go to post
          • owz
            replied to Display Strings from a 2 dimensional array
            in Java
            No problem have solved it now needed 2 diclear the array
            salesFiugres[0][0];...
            See more | Go to post

              Leave a comment:

            • owz
              started a topic Display Strings from a 2 dimensional array
              in Java

              Display Strings from a 2 dimensional array

              This is what im trying 2 get
              Sales Figures for 2006 in £000's


              Sales staff name 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Max Min Total

              John Smith 24 30 15 17 30 15 86
              Joe Jones 24 19 10 20 24 10 73
              Jill Evans 24 21 20 28 28 20 93

              Quarterly totals 72 70 45 65

              Total sales are £252,000


              Star performers...
              See more | Go to post
              • owz
                replied to Leap year calculater problems, validating days
                in Java
                thanx very much, cant beleive its so simple. you where a great help.
                See more | Go to post

                  Leave a comment:

                • owz
                  started a topic Leap year calculater problems, validating days
                  in Java

                  Leap year calculater problems, validating days

                  Ok, I am making a program (java class file) 2 work out if a date entered is valid or invalid for the day, month year, and for leap years.. dd/mm/yyyy .
                  I seem 2 have gotten it 2 validate the year and month, but my code errors on the day validation.

                  Error(91,38): variable daysInMonth might not have been initialized.

                  Any thoughts, all help welcome. I only ask as a last resort as it is frustrating me 2 pulling...
                  See more | Go to post
                  • owz
                    replied to Show the highest and lowest price item sold this month.(SQL)
                    in Access
                    thanx very much, i didnt think it was that simple.
                    See more | Go to post

                      Leave a comment:

                    • owz
                      started a topic Show the highest and lowest price item sold this month.(SQL)
                      in Access

                      Show the highest and lowest price item sold this month.(SQL)

                      Hi again had some more problems, all help welcome. Access 2000, SQL


                      My problem is as stated in the title. I want 2 display the highest and lowest priced car sold for this month. This is what I have.

                      Code:
                       SELECT  CarSales.Car_Reg,MAX (Purchased_Price) AS Highest_Sale
FROM CarSales
WHERE  Purchased_Price=(SELECT MIN(Purchased_Price)AS Smallest_Sale
                      ...
                      See more | Go to post
                      • owz
                        replied to The Sum of data, Dependant on Dates of the month
                        in Access
                        Thanx work perfect.
                        u where a great help.
                        See more | Go to post

                          Leave a comment:

                        • owz
                          started a topic The Sum of data, Dependant on Dates of the month
                          in Access

                          The Sum of data, Dependant on Dates of the month

                          Working with ACCESS 2000 SQL, I’m getting very frustrated with it now so
                          Any ideas would be well appreciated

                          I want the sum of the sales of a Salesperson for a specific month i.e. the month before.

                          Last month:
                          i.e. Salesperson ££SOLD
                          1 £800
                          2 £350


                          and so fourth for all my sales...
                          See more | Go to post
                          • owz
                            started a topic SQL output problems
                            in Access

                            SQL output problems

                            Need help my code does not output correcly... i need it 2 output the sum of the prices from the month befor. instead it output the summ from all months,, any help would be welcome





                            SELECT DISTINCT CarSales.Sales_ Staff_No, (SELECT SUM(CS.Purchase d_Price) FROM CarSales AS CS
                            WHERE CS.Sales_Staff_ No = CarSales.Sales_ Staff_No) AS Sales_for_last_ 6_month, CarSales.Date_O f_Purchase
                            FROM CarSales...
                            See more | Go to post
                            • owz
                              started a topic Help with adding sales by Month
                              in Access

                              Help with adding sales by Month

                              Dont no 2 much about SQL any help welcome.
                              OK, need 2 creat an SQL for the total cost of the cars sold by each salesman in the past month . i.e SalesMan 1. Sold £ amount

                              I have this so far

                              SELECT DISTINCT CarSales.Sales_ Staff_No, (SELECT SUM(CS.Purchase d_Price) FROM CarSales AS CS
                              WHERE CS.Sales_Staff_ No = CarSales.Sales_ Staff_No) AS Sales_for_last_ 6_month, CarSales.Date_O f_Purchase
                              FROM CarSales...
                              See more | Go to post
                              No activity results to display
                              Show More
                              Working...