Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by brsterner
-
Help with SQL query
Max...you're the man. Its not pretty but I've nearly got it working. Just need to figure out how to incorporate post-July 1 values (between last updated and today's date) - but that's the least of my worries. I'm 95% there and all thanks to you. Your help potentially saved me days of time. Its a...- brsterner
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Help with SQL query
Thanks for your reply Max, what I'm basically trying to do is return a result set that gives the effective MWD value, by day, between a range of dates. An MWD value is typically updated once per month per well, so those values carry over each day between updates. Problem is the update dates are...- brsterner
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Help with SQL query
All - I have what I think, for someone with any level of SQL skills, should be a relatively routine problem to solve. Right now I have a table called MWDHistory which relates a well to an MWD value effective from a specific day forward until updated again (typically monthly). The table is...- brsterner
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
