Hello,
I have just been send the answer to my problem
To fix the problem as it stands you need to create a join in the query [qry - final invoice] between [dates of service] in the tables [tbl - orders - details] and [tbl orders - sales].
It was a normalization problem.
Thanks for all those who had a look at this for me.
Regards
Gordon
|