Recent content by betheball

Great idea. Thanks. I did find that if I copied and pasted the autoshape and text out of the table and into a new Word document I could again access the autoshape. I could then manipulate it and then paste it back into the original document.

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

Let me tell you what I came up with and you tell me if there are any problems with it. It seems to work as I want, but the Results table only has a couple of test records in it so is hard to know for sure if this will continue to work. I used the Last function on all the fields I wanted to add...

Thanks Tess. This works: SELECT SERPTestInput.ID, Max(Results.testDate) AS maxDate FROM Results RIGHT JOIN SERPTestInput ON Results.testID = SERPTestInput.ID GROUP BY SERPTestInput.ID; Now I have one more hangup. I need to add a couple of fields from the Results table, but because those...

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

Thanks again. I forgot that the same test can have multiple failed entries and up to one successful entry, because the test is rerun until it passes. So, I will need to rethink how to do this. I think I will stick with what you gave me above and then perhaps add run a second query to get the...

Thanks antomack. That works as advertised. So since it works, of course I want to complicate it. The issue I have now is that each test will be either successful or failed. However, some have yet to be tested, meaning they don't appear in the Results table at all. I would like to move my...

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

Thanks alot.

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

Brilliant. Plus I learned something. I didn't know you could add a second criteria to the JOIN portion of the query. Thanks for the help.

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