I have created a query (query2) which looks up a value from another query (query1). The reason i used D lookup is so the form remains editable as the query in query1 is a sum.
When i run query2 it shows the dlookup (sum function in query1) as a currency (as it should). But when i display this in a form, it shows only as a number.
I have set the format of this (in both query and form) to currency, but it doesn't work.
I have attached a simplified version of my database showing the problem.
To get to the problem field, open DB, click on current projects, click on project 64 (skip & sing). The problem field is current facilitator spend (and current spend in other categories).
When i run query2 it shows the dlookup (sum function in query1) as a currency (as it should). But when i display this in a form, it shows only as a number.
I have set the format of this (in both query and form) to currency, but it doesn't work.
I have attached a simplified version of my database showing the problem.
To get to the problem field, open DB, click on current projects, click on project 64 (skip & sing). The problem field is current facilitator spend (and current spend in other categories).