Dear all,
I'm trying to make a database for price offers and it's revisions but when I make a report for the offers all the revisions being listed, but I need only the last revision for every offer
please help me in the above issue.
Dear all,
I'm trying to make a database for price offers and it's revisions but when I make a report for the offers all the revisions being listed, but I need only the last revision for every offer
please help me in the above issue.
Difficult without knowing your data structure. Does this help?
http://www.baldyweb.com/LastValue.htm
thank u very much i think it will work, i'll try and feed u back
No problem, and welcome to the site by the way!
i need a simple way to create a report or query to calculate the total amount of the last revision taking into consideration that each revision contain one BOQ which contains more than one item.
The first thing I would do is clean up the object names.
Shouldn't use spaces, punctuation or special characters (underscore is the exception) in object names. You have slash, apostrophe, parenthesis, dash and question marks in object names. This will cause you headaches.........
I'm just sayin............