Search results for query: *

The search feature is down so please forgive me if this has been asked & answered. Anyway... How can I schedule a command line task with the XP scheduler? If not with the scheduler, is there another way? Thanks in advance, Krickles | 1.6180

I have the following query: SELECT t.ticket_id, t.truck_id, co.ship_date FROM ticket t INNER JOIN customer_order co on co.customer_order_id = t.customer_order_id INNER JOIN truck tr on tr.truck_id = t.truck_id ORDER BY co.ship_date, t.truck_id The result set is similar to...

Report purpose: calculate variable incentive Problem: can't sum my formula field even though it displays as numeric when hovering over it and I have tried converting the results with ToNumber. Current display: GH#1: Order_Plant GH#2: Employee GH#3: Ship_Date Detail(3 fields): Ticket_Number |...

I have been asked to set up an automatic email that will send a text message to a group of managers each night with the current day’s production and the next day’s projected production. The reporting app I built already contains this information and the database updates the info each night...

I am trying to dynamically create href links based on database values. The problem occurs with only one field. Details:MS SQL Server 2000 Data type: varchar(50) Field name: plant Generic data sample: XX[single blank space]PlantName Examples of data: 30 East Birmingham 40...

I am returning a recordset with the following query: SELECT sdl.supplier_division_id, s.supplier_id, s.supplier_name, sdl.status_id, sl.status_desc FROM supplier AS s INNER JOIN supplier_division_lu AS sdl ON sdl.supplier_id = s.supplier_id INNER JOIN division_lu...

I'm using the getrows method to return an array. No matter which table I point to, I only load half of the records (regardless of total record count). Code chunk below: Set objRec = server.CreateObject("ADODB.Recordset") objRec.Open "select * from division_lu", objConn...

My report deals with three tables. Primary table = customer_order; Secondary table = delivery_times, Tertiary table = employee_times. The links are: customer_order.order_id to delivery_times.order_id & delivery_times.employee_id to employee_times.employee_id The problem occurs with...