Search results

I inserted some autoshaped into my document and then in the "Order", sent the shape behind the text. Some of the shapes were in a table and others are behind bulleted lists. Now I want to delete them, but cannot access them. I assume it is because the shape went not only behind the text, but...

The following query works properly: SELECT DISTINCT UPS_Invoices.TrackingID FROM UPS_Invoices so does this one: SELECT DISTINCT AR_19InvoiceHistoryTracking.TrackingID FROM AR_19InvoiceHistoryTracking INNER JOIN ARN_InvHistoryHeader ON ARN_InvHistoryHeader.invoicenumber =...

Table A is an employee table. Table B is an attendance table that shows that reflects hours worked by employee on a given day. However, if an employee doesn't work on a given day, there is no record for that employee in the attendance table on that day. Herein lies the problem. I want a...

I have a table called Tests that contains 80+ tests that need to be performed on our system. A second table is Test_Data. It contains the test results. I need a query that will pull the most recent test data for each test in the Tests table. So supposing there are 83 tests, I should only get...

I have this query: SELECT testScreen, Count(ID) AS testCount FROM SERPTestInput GROUP BY testScreen It returns a count for each testScreen that appears in the table. Then this query returns the same thing except it joins another table and adds the criteria that the status for the record must...

I have a table wherein is recorded each employee's daily output, by date. I created a query that will tell me the highest volume daily ever for each employee. SELECT Closures.IDRS, Max(Closures.[10Volume]) AS MaxOf10Volume FROM Closures GROUP BY IDRS; However, I would like to also get the...

I have 2 tables. One simply lists every day of the year. The other, lists various data, including a date field. I need to create a query that will tell me how many records exist for each day of the year. Not all days of the year exist in the table, but I need to display every date of the...

I have a table that lists 25 tests that need to be performed on a system. I have a second table that includes the results of the test. Tests are repeated until the particular test is successful. So, an item may have 3 or 4 corresponding records in the Tests table, with only one having a...

This may be mnore of a ASP question, but I am not sure. In a db that is for reserving campsites, there are frequently 10-12 records where the value for every field is the same except for the campsite number, ie, the reserving person's name, the date, email address are the same for each record...

I have a field in my db that is numeric with a size of "Decimal" and a scale of 1. Most values in the field are like 19.3, 27.3, etc. However, others are whole numbers such as 25, 37, etc. I am trying to write a query that will populate two new fields, one with the number left of the decimal...

Not sure the best place to post this, so I'll try here. Feel free to move it if needed. I have a .asp form that includes a dropdown menu that allows multiple selections. The dropdown is populated by a table in an Access db. So, when a user makes his/her choices I will send the user's ID and...

In my current table structure, there is a set of four columns named, hpothetically, T1, T2, T3 and T4. For each record only one column has a value. The rest are blank. I've decided that is a bad idea. So I am creating a new column, T5. Is there a way to merge the data from the four existing...

This may be bad database design, but that ship has sailed. I have a table that stores reservations, such as for a hotel or restaurant. I decided the best route to go was create a new record for each room/table reserved. This works beautifully, until one person reserves several rooms or...

I have 4 fields in my table, Employee, InputDate, Volume, and Hours. I want to display the Employees down the left column, the InputDate across the top and then Volume divided by Hours in the middle. I tried this: TRANSFORM (Closures.[10Volume]/Closures.[10Hours]) AS AvgOf10Volume SELECT...

With the help of IanH I was able to throw together this SQL: SELECT Month(ReviewDay)&Year(ReviewDay) AS MyMonth, Count(*) AS MyCount, Sum(IIf(SignedOn-SchTime<3 And SignedOff=0,1,0))+Sum(IIf(SchTime-SignedOff<3 And SignedOn=0,1,0)) AS HoursMet FROM Adherence GROUP BY...

I think it likely this can't be done, but thought I would ask. I need to try and get two counts with one SQL. I want a total record count grouped by month and then a count of only those records where a certain field value is "Yes" also grouped by month. As I write this it is seeming less and...

I have a table with a price field. The data type is currency. For reasons unbeknownst to me, many of the values now have 4 decimal spots. I have an ASP page whereby the site owner can change prices in the db. The owner completes a form whereby he enters the old price and then the new price...

I am guessing this has been done many times, but can't quite get it right. Each day I input to the db the date (myDate), the number of items produced (Items) on that date and the number of hours worked on that date (myHours). What I want to do is create a query that will bring back the total...

I am working with a what I feel is a poorly designed database. A typical record has a productID and then seven different colors. Each color is a text field with a value of "Yes" or "No". I am trying to write a query that given the ID number, will return only the fields from that record with a...

I am trying to get creative here. Maybe you guys will have a better (easier) way to do this. I am actually trying to do this on a .ASP page, but my question I think relates to the query itself. I am trying to get not the top 10 newest records but the second 10 newest. So I am using this SQL...