Lance-
Glad to hear it works for you. It *almost* worked my first pass through, but was reporting the wrong day at the start of a string of days with the same price. I also found I was using the same code in several places, hence the GoSub calls.
John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
(Paris, France)
On Feb 1, 2017, at 8:42 AM, Lance Gallant istari.6@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
John
So I changed the table structure as per your suggestion, edited the query in the function to work with the fields my rates table and voila, it works perfectly. Not only that but thanks to your clear commenting, I understand the steps behind what you did. So a huge huge thanks to you.
I'm glad you found it an interesting challenge :-)
Lance
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (7) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
.
__,_._,___
Tidak ada komentar:
Posting Komentar