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

    Comparing dates

    Hello all, I am comparing two dates in sql and it seems to be missing some records. the statement i am running is: select next_insp_date_Fw, last_insp_date_Fw, archive_status_Fw, insp_description_Fw, getdate() from user_defined19_fw where vehicle_id_fw = '1105' and next_insp_date_fw <=...
  2. FunkyBunch

    Format a number

    Hello All, I am trying to format a date to have no decimals. I am not sure if there is a function I can use. Select weightulw_fw --want to show with no decimals from vehicles Thanks y'all
  3. FunkyBunch

    Select Historical Vehicle Infor

    Thank You Borissov, that looks like it will work. I will not have time to test it today but i will keep you posted on my progress. Thank you so much!!!!
  4. FunkyBunch

    Select Historical Vehicle Infor

    Here is some sample data: In The Database: Column Order: Vehicle ID, Equip ID, Date Added, Date Removed, Record Number 1 20 1/1/2007 1/25/2007 1 2 20 1/25/2007 NULL 2 1 25 5/16/2006 NULL 3 4 14 9/7/2005 5/20/2006...
  5. FunkyBunch

    Select Historical Vehicle Infor

    DOes anyone have any ideas? Or is my post a little bit to confusing? Or Large?
  6. FunkyBunch

    Select Historical Vehicle Infor

    Hello All, I am currently using SQL 2005. The select statement I am trying to make will pull in the equipment id, a string literal describing the transfer.(Addition, Deletion, Transfer To, Transfer From), and the unit number the vehicle was transferred from/to. This is the SQL i currently...
  7. FunkyBunch

    In statement inside Case Statement

    Nevermind, I guess I would have to give supply a field to be in the sun-query. :& Thanks,
  8. FunkyBunch

    In statement inside Case Statement

    Hello All, I am currently creating a view and was wondering if it was possible to use an in statement within a case statement. Here is my current SQL: ************************************************************ select access_equip_Fw, case when (date_mounted_Equipment_removed_fw is null) and...
  9. FunkyBunch

    DataSource communication Failure

    Thanks for the quick response Synapse, but it was just an error within Crystal Reports. I just logged off the server and logged back on and everything seems to work fine right now.
  10. FunkyBunch

    DataSource communication Failure

    I have created a few reports within CR9 using SQL Server 2005 and after restoring the database to a more current version. I get this error for each table: The database table "Vehicles_fw" cannot be found. Proceed to remove this table from report?" After clicking no through all of the warning i...
  11. FunkyBunch

    Display Non-related group value

    I think it may be best to just let this one go, I am going to investigate database views to fix this problem. Thanks for your help and i apologize for my communication.
  12. FunkyBunch

    Display Non-related group value

    What i would want to show in the transfer to/from field is the unit # of the vehicle that the equipment was last attached to. For example if the equipment(22) was moved from unit 3 to unit 1. for unit 3 it would show Unit # Equipment Transferred To/From 3 22...
  13. FunkyBunch

    Bad Select Formula

    I have found the problem, it was a join with the models_fw table. I had the left outer join from models to vehicles when it should have been vehicles to models. Thanks a ton for your help!
  14. FunkyBunch

    Bad Select Formula

    I do not have a group selection or section suprresion. but here is the sql query: SELECT DISTINCT "VEHICLES_FW"."VEHICLE_ID_FW", "ALLOCATION_REASONS_FW"."DESCRIPTION_FW", "DEPOTS_FW"."DEPOT_NAME_FW", "VEHICLES_FW"."BASE_LICENSED_STATE_FW", "USER_DEFINED1_FW"."DESCRIPTION_FW"...
  15. FunkyBunch

    Bad Select Formula

    The formula for {@UnitisBlank} is just {?Unit} = "" which checks to see if the user left the parameter blank. This field cannot be null as you are only able to select the blank record or an actual unit. The problem with this formula is it is not returning the correct amount of vehicles...
  16. FunkyBunch

    Bad Select Formula

    Hello All, I am creating a report in CR9 with SQL 2005. The report is to display all vehicles that have had a status change within a time period. Here is the first part of my selection formula: The third line of the formula uses 2 isblank fields that check if the parameter has been left...
  17. FunkyBunch

    Display Non-related group value

    Here is just a shot of the sample data. The first column is vehicle id, the second column is equip ID, the third is date added and the fourth is date removed. 4 2 1999-12-01 00:00:00.000 NULL 6055 3 2003-03-01 00:00:00.000 NULL 6 4 1999-12-01 00:00:00.000 NULL 10 5 1992-03-01 00:00:00.000...
  18. FunkyBunch

    Display Non-related group value

    How would i go about obtaining the vehicle number if i were to go about the subreport approach? Is there a particular formula i would use? Thanks for your help!
  19. FunkyBunch

    Display Non-related group value

    What about using an SQL Expression? Is there a possible way to make that function in this scenario?
  20. FunkyBunch

    Display Non-related group value

    Or would it be smarter to create a view on the database and just use the view?

Part and Inventory Search

Back
Top