I would like to format the field [winLoss] to show as a 3 place percent. It currently displays as a 2 digit percent and I am not sure just how to go about this.
Here is the current code.
Thanks,Code:SELECT ID, Div, Team, W, L, WinLoss, GamesPlayed FROM SportsMLBLeagueQry WHERE Div = "AL East" ORDER BY WinLoss DESC;
Jim O
Figured it out, Format([WinLoss],"0.000%")