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 derfloh 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: tdrBates
  • Content: Threads
  • Order by date
  1. tdrBates

    Strip last 3 characters from the field in the select case statement

    //Command.trip_id_external is a 10 digit string. //For example for the first Case Command.trip_id_external = '2293098000'. //How can strip off the last 3 digits of Command.trip_id_external in the select {Command.trip_id_external} statement below? //I need the trip_id_external string...
  2. tdrBates

    How do automate a report to query records for a specific time interval?

    How do you automate a report to query records for a specific time interval?
  3. tdrBates

    Schedule report to run only peak times every day

    I need a report or two reports that is scheduled to run from InfoView at 9:30am and 6:30am The Schedule report that runs at 9:30am would only pull records from 6am to 9am. The Schedule report that runs at 6:30pm would only pull records from 3pm to 6pm Below are two forumulas I used to Schedule...
  4. tdrBates

    How can I get the bottom 5 routes of this report

    I am trying to get the bottom 5 routes of the attached report based on "Ontime Percentage" I have attached the *rpt file. Thanks for any assistance.https://files.engineering.com/getfile.aspx?folder=aaa29915-9250-4e57-a592-1d1c035af463&file=SummaryByRoute_bottom_5.rpt
  5. tdrBates

    Highlight any record in data-set in which several fields within the record is duplicated

    Using Crystal Reports, how can I highlight any record in a data-set in which several fields within the record is duplicated, but not all fields. For example in the attached spreadsheet the fields listed below are duplicated, but not all fields within the record are duplicated. If the fields...
  6. tdrBates

    How does "decode" function work in SQL Order By clause?

    In my SQL Query Command the Order By clause has the "decode" function. Can someone explain what this function does to the "Sort" below? ORDER BY cmta.vw_headway_data.signid, cmta.vw_headway_data.direction, Route, cmta.vw_headway_data.serviceid, trapeze.linestop.sequence...
  7. tdrBates

    Group Expert function forcing changed sort throwing totals off

    Would it be possible to Group By Route and Peak and the attached SQL Query? When I “group by the Peak field” using Crystal Report Group Expert this forces a change in the sort and throws off the number of “Ontime, Late, Missing_Data”. My thought was to add the “Group By Clause” within the SQL...
  8. tdrBates

    Join two tables to pull specific field into the report

    I need to be able to join "Table_1.TRIPID" and "Table_1.SEQUENCE' to "Table_2.TRIPID" and "Table_2.SEQUENCE' to pull "Table_1.schHwy" Table_1 "schHwy","TRIPID","SEQUENCE" 0,"1834556",24 0,"1834556",3 0,"1834556",4 0,"1834556",5 0,"1834556",6 0,"1834556",7 0,"1834556",8 0,"1834556",9...
  9. tdrBates

    Use MS Access VBA to write table data to text file

    I need to be able to write the dataset below to a text file "schHwy","TRIPID","SEQUENCE" 0,"1834556",24 0,"1834556",3 0,"1834556",4 0,"1834556",5 0,"1834556",6 0,"1834556",7 0,"1834556",8 0,"1834556",9 0,"1834847",1 0,"1834847",10 0,"1834847",11 0,"1834847",12 0,"1834847",13 0,"1834847",14 I...
  10. tdrBates

    Insert row at specific location within table

    I need to insert a row below the row that has fields A thru E 004-01, SOUTHBOUND, 18, CHIC, MLK with the same fields except that field C should be 4 instead of 18. This row occurs several times throughout the table and I want to insert a row after each occurrence. Any suggestions on how I...
  11. tdrBates

    Find and Replace Quote

    I'm trying to replace the quotes in the field below with nothing. I'm using MS Access 2000 tStamp,bus,route,run '2005-01-04 06:18:06.000',7412,331,33101 I get error '3144' - Syntax error in update statement below. Can someone help me correct this? Public Function FindAndReplace(ByVal...
  12. tdrBates

    sum two fields and place in detail section

    how can I sum two fields and place in detail section of my report? thanks for any assistance.
  13. tdrBates

    Can MS Access update a Sybase table

    We would like to update the route and block fields in the Sybase TableA with route and block fields in MS Access TableB based on the following conditions: update tableA set TableA.block = TableB.block, TableA.route = TableB.route where format(timeOnly(TableA.ts)) between TableB.tmMin and...
  14. tdrBates

    Does Immediate IIf statement have else clause

    I'm trying to create a field that places different TP_NAME_1 in different SECTORS. If TP_NAME_1 = "ARBORETUM" I can place it the Northwest Sector. However I would like to do this for several TP_NAME_1. I've written the query below in MS Access QBE payne. How would I use an else clause or...
  15. tdrBates

    Unable to Edit and Update Recordsource

    I'm trying to change the LINEABBR field to 18. Can anyone figure out what's wrong with this function? Thanks BLOCKNAME LINEABBR NODEABBRA NODEABBRB 004-02 4 AIRP MLK 004-02 4 AIRP MLK 004-02 4 AIRP MLK 004-02 4 AIRP MLK 004-02 4 SPRI MLK 004-02 4 SPRI MLK 004-02 4 SPRI MLK...
  16. tdrBates

    Drop MS Access table if it exist

    Can I run code similar to the example below? If tablename exist then Run.SQL "DROP TABLE tablename" End if
  17. tdrBates

    Converting Access 97 to Access 2000

    When converting Access 97 application to Access 2000 application, we converted all occurrences of Database and Recordset to DAO.Database or DAO.Recordset to query from Excel. Will we have to do this in all Access 97 to Access 2000 conversions? Is this the best way to solve DAO compatibility...
  18. tdrBates

    Force leading zeros in front of a number

    How can we force a number to always be 4 digits in length? We're trying to pad a number with leading zeros. Is there a function in MS Access that can do this? Example: "0008" or "0011" Thanks
  19. tdrBates

    synchonizing records on two subforms

    I'm a novice MS Access programmer. I have a MainForm with SubForm1 and SubForm2. I would like to synchronize records between SubForm1 and SubForm2. The code below gives me the error "No current record". How can I synchonize records between SubForm1 and SubForm2? Private Sub...

Part and Inventory Search

Back
Top