Eric the Viking
Registered User.
- Local time
- Today, 07:18
- Joined
- Sep 20, 2012
- Messages
- 70
I have a form to show debits, receipts and a balance for members of my club. The form is based on a query (qry3 which calculates balance from the output of qry1 and qry2) that is itself based on two queries (qry1 and qry2 which calculate the sum of debits and receipts) to produce the required calculated results by member. All the queries when run on their own will display currency properly with a leading £ sign. However, when the form opens only the balance value calculated by qry3 displays with the leading £ sign. The fields on the forms are all have the currency format. Is there a way to overcome this issue?