Hello all,
This is my first time to post on AccessForums.net and apologize if this is not the best forum to post in, but from my beginner's knowledge of Access, it seemed logical. I understand basic one-to-one and one-to-many relationships, but that's about it for me.
Background of problem:
I'm a hydrologist trying to set well measurements to a continuous list of dates, as the well measurements are not continuous.
Specific problem:
I've attached a sample of what I'm working with to add context to the problem. The measurements are stored as they appear in the table 'Well_Measurements'.
What I have no clue of doing is creating a relationship and query that could possibly create the table 'Desired_Data_Output'.
More info:
I setup a function in Excel that would search for two criteria and pull the measurement into correct cell, but it only works when applied to a small portion of the worksheet. When applied to larger portions of the worksheet, Excel will freeze as it drains resources.
Instead of the 6 wells and 25 associated measurements in my example, I have 7,000+ wells and 1,000,000+ measurements.
Any help is appreciated. It would be great if you repost the database file "corrected" to help me out.
A million thanks,
jmblackstock