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
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'.
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
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,
(248.0 KB, 8 views)
Reply With Quote
Windows XP Access 2003
Join Date Jan 2010
Location Victoria, Canada
You could likely get something similar to your results with a crosstab query, but to be sure, I'll need to know the answers
to a couple questions first:
a. Do you take measurements every day? If not, is it important to see those (empty) days in your results?
b. Do you ever record two or more measurements on the same well on the same day?
If a crosstab doesn't work for you, there are other ways.
P.S. - I'd be interested to see your attempt using Excel.