Search results

I have to work with two tables - Service Request Table and Audit Talble in order to get the data I need. One of the fields in the Service Request Table contains a field named: Service_Request_No. The data in the Service_Request_No field shows the serv. req. no in the following format...

I am trying to produce data in the following format: Distance Total 14.0 > x => 14.5 2637 14.5 > x => 15.0 3580 15.0 > x => 15.5 2461 15.5 > x => 16.0 1359 16.0 > x => 16.5 1042 16.5 > x => 17.0 878 17.0 > x => 17.5 810 17.5 > x => 18.0 889 I'm not sure what function in Access I...

I created a query to pull orders that have a distance = or > 14.0, but I need to know if there is a way to possibly manipulate the results (or the query itself). I have distances between 14.0 and 50.0, but I need to provide a count of the total number of orders in 500 ft. increments (i.e...

I have to work with two tables to run a query. The first table has a field titled QUAL_TRK_NO, but the way the data appears in the field is as follows: 00000000000000000000000000000002721897 (leading zeros) The second table has a field titled KEY_INFO. This field contains the same data as...

I need to pull only the records in a table with a Due_Date field that have a due date of less than 7 days from the current date. Please help. Thanks. Example: due dates are 01/07/01 12/17/01 12/29/01 I would want only the 12/17/01 record pulled. [This message has been edited by lp4799...

I used a Request Table and performed a query to return due dates between 11/26/01 and 12/03/01 for disconnected order, and saved the query. I joined that query to an ORDER Table, and I want to find the due date for the New orders from the ORDER Table that are less than 90 days from the...