surfernat
IS-IT--Management
- Feb 27, 2008
- 38
I really cant explain this its very odd. Everything works except one field. To explain the problem I need to explain the overall setup so please bare with me.
DATASOURCE
The data source is an Excel 2003 spreadsheet. It is used to record outstanding balances. I have four columns 0-30days, 30-60days, 60 -90 days and older. These columns show the age of each outstanding balance. In the same spreadsheet I have a field that calculates which letter they are to recieve. ie 0-30 letter a, 30-60 letter b, etc etc
WORD 2003 DOCUMENT
I have created 4 letters Latter a, letter b, letter c and letter d.
When you open letter d a query runs which selects data from the excel sheet and populates the relevant fields in the document.
In each letter I have the same table showing outstanding balances. ie
0-30 30-60 60-90 Older
£- £- £200.00 £-
If the client has an oustanding balance no older the 30 days then the total will display in the 0-30 column, if he hasnt then the field should automatically display £- mainly to keep it neat looking. This works really well and I using the following syntax to display the described results
{MERGEFIELD"0-30" \#"£#,##0.00;(£#,##0.00);"}
Now all works fine except 60-90 it has the exact same syntax however the results are not formatted as specified, the brought in figure is left unformatted instead of being £200.00 its just 200 and when no figure is brought in its left blank instead of £-. I have copied the 0-30 syntax and pasted it in the 60-90 and then amended the mergefield but the results are same.
I have checked the source data and its formatted as £ with two decimal points. It just doesnt work for 60-90.
Does anyone have any ideas what else I can try please. Its really annoying me!! Thanks
DATASOURCE
The data source is an Excel 2003 spreadsheet. It is used to record outstanding balances. I have four columns 0-30days, 30-60days, 60 -90 days and older. These columns show the age of each outstanding balance. In the same spreadsheet I have a field that calculates which letter they are to recieve. ie 0-30 letter a, 30-60 letter b, etc etc
WORD 2003 DOCUMENT
I have created 4 letters Latter a, letter b, letter c and letter d.
When you open letter d a query runs which selects data from the excel sheet and populates the relevant fields in the document.
In each letter I have the same table showing outstanding balances. ie
0-30 30-60 60-90 Older
£- £- £200.00 £-
If the client has an oustanding balance no older the 30 days then the total will display in the 0-30 column, if he hasnt then the field should automatically display £- mainly to keep it neat looking. This works really well and I using the following syntax to display the described results
{MERGEFIELD"0-30" \#"£#,##0.00;(£#,##0.00);"}
Now all works fine except 60-90 it has the exact same syntax however the results are not formatted as specified, the brought in figure is left unformatted instead of being £200.00 its just 200 and when no figure is brought in its left blank instead of £-. I have copied the 0-30 syntax and pasted it in the 60-90 and then amended the mergefield but the results are same.
I have checked the source data and its formatted as £ with two decimal points. It just doesnt work for 60-90.
Does anyone have any ideas what else I can try please. Its really annoying me!! Thanks