Good day all


I just want to say a great big to everyone that helped with this project and pointed me in the right direction because I finally figured it out. So I used the mod db that Steve setup and used the Dlookup formula that June provided but still received an error in Licence_Amount field and with alot playing around, altering the formula and then just F#@$ it up coming to a . Anycase so I created a new db following the same principle as Steve and again playing with the formula and somehow got it right, playing around with the field Data Types and relationships and then breakdown the Dlookup function and finally it all fell into place. The final results is in the db below. And again thanks, thanks, thanks. This forum is the best and always helpful within minutes of posting.

Demo1.zip