Is it possible to use the Query to view saved transactions on a table by using a form NOT a report? Sorry people my question sound a bit weird, if this was possible I will be happy. We have the business rule as below:
(1) All transactions must be approved by a senior official direct in the system, example the captured or saved data by clerks can be deleted anytime if not approved and once the transactions are approved it impossible to delete them
(2) The approving form is only seen by a senior official, and so the lower staff have no chance of seeing it at all
(3) Only approved transactions can finally reflect in the general ledger
The approving form is the one which I want to fit the query so that the managers approving the documents do not only rely on the printed journal but can as well see the transactions on the form like a min report.
All is working well and everyone is happy about it, but if the above can work then that can be a good thing
If Dsum, ComboBox & Dlookup are able to bring figures on a form which are regarded as min queries why the actual query can’t do the same???