Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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