I have been tasked with maintaining an existing access ADP file with SQL server 2005 backend.
The client wants a new report. I have created a temp table in SQL Server and filled it with the appropriate data, which is then summarized with a view in SQL Server.
On the access side, when I link the report to the view, the fields won't format. I have the format set to standard with 0 decimal places which should be 1,234 but the report shows 1234.
Also on the report I have line total fields which are formatted the same, but actually show 1,234.
Any help or guidance would be great, thanks.