Why not just set the Format property to Standard with 0 decimal places. Don't do anything with the control source or anything in the record source query.
Duane Hookom
MS Access MVP
________________________________
> From: robinski@mymail.net.au
>
>
> I have a report that produces totals as 123456 . I would prefer that
> a comma were used to separate the figures. 123,456
>
> My attempt has failed: Format$([SumOfVisitors,"###"", ""###")
>
> What have I missed?
>
> Many thanks,
>
> Robin Chapple
__._,_.___
MARKETPLACE
.
__,_._,___
Tidak ada komentar:
Posting Komentar