Search results

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

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

Thanks Wayne. That was my inclination as well.

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

Wow! Didn't expect that much of a response. Thanks. T5 is not a calculated field, simply text. I just thought it stupid to have four fields with only one of them completed per record. So, the issue is to move all the values to T5 and then delete T1-T4 after the values are moved. What was...