V
Vic
I have a report showing totals of items purchased and
showing a total amount at the bottom of the report. My
database is stored in SQL Server and I'm linking the
tables from Access because I'm using an Access interface
with report.
However, I do not want to calculate the total dollar
amount from the items in the report. I have a view in
SQL server that I link to and I want to show the total
from there. I'm able to show the amount, but I can't
make it into Currency format. There are no options in
the textbox property for format. Please help.
TIA,
Vic
showing a total amount at the bottom of the report. My
database is stored in SQL Server and I'm linking the
tables from Access because I'm using an Access interface
with report.
However, I do not want to calculate the total dollar
amount from the items in the report. I have a view in
SQL server that I link to and I want to show the total
from there. I'm able to show the amount, but I can't
make it into Currency format. There are no options in
the textbox property for format. Please help.
TIA,
Vic