Search results for query: *

Good one! That is the problem with LEAN. We should call it POYJ - Phase Out Your Job.

I just took on this project and I had a coworker who manually updated both data and the charts in 100s of worksheets; no joke 100s. I have now automated all of our analytical tools to populate a Database I created and am now woking on autopopulating all of the management tracking sheets, out of...

John - Perfect! That did exactly what I wanted to do. I now have a dynamic graph for all data enterd since day one and continually updated and another graph that only plots the last 100 data points. It is much easier to do my stats at a glance with these graphs. Perfect! Steve

I have some statistical data imported into an Excel sheet from an Access Query. The data from the Query is updated each time the file is open and new data is appended to the data series. I want to create a graph in Excel that updates when the data updates and only displays the last 100 data...

Thanks PH. I couldn't get what I was looking for in your suggestion so I configured my parent table to have a starting ID and a final ID. In my query I use a Left Outer Join with a between starting ID And final ID. Works great. Thanks again for your help! STV

PH, Thanks! I'll try it and let you know. Steve

I'm pretty new at Access and Database development so I hope I got the SQL code correctly for you. I opened My Query in question and I selected View>SQLView. Here is the SQL code from my Query: SELECT RPM_Measurement.Date, RPM_Measurement.Filename, RPM_Measurement.Wafer_ID...

PH, Sorry for the confusion. I may not know exactly how to ask the question. I don't know if I need to populate blank cells with the value of the cell above the blank cell or if I need to find out how to link a row of parent information to a series of child information when the relationship...

I have a one to many relationship between multiple tables in Access. In one particular query I am pulling data from the parent table where the value of Results_ID_start is the direct relationship to Results_ID in the Results table. When I query the two tables I do a one to many relationship...

Thanks for the input Rofeu. Per your suggestion I developed multipe Queries that essentially group the data by measurement type and data type. I have written VB code to import the individual Queries as spreadsheets within the Excel folder that Management uses to review the data and have...

In the Outlook Calendar, select the Calendar Coloring icon in the standard toolbar (looks like a 3x3 colored tabel). Here you have the option to Edit Calendar Labels. You can select a Label, like Phone Call and edit it to say Client Site. Now when an employee is going to be a Client's Site...

OK; I have a dataset that is imported to an Excel Worksheet from an Access Database Query. The data is set up in columns with headings as below: Date Sample_ID Meas_Type Data_Type Average 9/12/2007 1363-rpm-aa 2 5 847.7 9/12/2007 1363-rpm-aa 2 2 848.9 9/12/2007...