Recent content by jwillet1

The database is used form logging test procedures for timing tracking. An engineer will log a test at the lvl 6 requirement and log the time for that test run. As we have close to 300 engineers you can see how the amount of lvl 6 items will increase very quickly for a given product. Management...

I have a table that i have to incorporate in to a tool I am currently working on. It is a large (3200 line) excel table. the 3200 lines are our level 6 test conditions. Each of those will roll up from level 5 to level 1 becoming grouped until level 1 includes only 3 lines. My question is...

I have a query i use to return some time lengths for test runs. The user inputs a start and end date and time for multiple test categories, the query will pull those results and use datediff to determine the length of the test. The issue is that a single test run, ie id 1032, can include...

I have a table that tracks, monthly and yearly, budgets and actuals for head count. As of now I have columns for month, year, budget, and actual. Recently i have thought that changing the budget and acutals columns to type and value would be more appropriate. For example: Current: CalMonth...

Thank you very much for the help, that is a nice elegant and readable method to solve my dilemma. I do have a question, I have never used it before so what is the purpose of the "Property" function? Why use property instead of something like just a variable? Forgive the question if the answer...

I have what I am going to call a chain query that works, however I believe there is a more concise and clear way to write it out. Here is what I want and how it works. The form where the query is essentially defaults to all records. There are three filter values that a user can choose...

It represents the test metrics that product are tested against. For example one might be sound under a certain condition.

Well I have the TestDetails table, that links the TestData table, this table stores each test session, to the ASRLineItems table, this table is the "test metric" table. Each test session, i.e. "TestID" can have more than one metric and each metric can be run more than once.

Hopefully I can explain this clearly. I have a database that tracks prototype testing. Each time an engineer performs any testing on a product they are to log the start and end times of their usage. The idea is to get an accurate utilization measurement of prototype usage. The company has a...

I figured out a way to do it. I have added a local table that stores the default information and a user input form that does not allow addition to the tables, only edits. This will hold the defaults and i am using a DlookUp to pull those values and use them in the new record input form.

That part i have got to work, however I would like to store those values, so the next time the user opens his/her copy of the database it has the values entered previously. I have been able to get the defaults to work in a single session. However i would like to store them in a way that allows...

I have a database that will be in use and to simplify user entry i am hoping to get some help in storing some default values for each user. Each user has a local copy of the front end of the database while the back end is stored in a network location. As part of the input process each user...

I am having an odd issue. I found and adapted a calendar database I found online. It is based on a database by Peter Hibbs. I tested all of it and got it working within its own database then I imported all of the pieces in to my actual dev database. All functions work correctly and all code...

Mihail -- Thank you so much for your help. I implemented your solution in to my dev database and everything works great, no slow downs and everything still works. The solution you came up with was great. I would never have thought to use a dmin lookup like that, but it works just right.

I have uploaded a copy of the DB, with only the pertinent tables and the query in question that I am using in the code. Basically I need how long each test status takes for each vehicle, and if the "teststatus" or "testPhase" is phase complete or vehicle release, respectively, the value should...