Format Concatenated String
Competent Performer
Windows 10 
Access 2010 64bit
I have the following code on a form that displays the data I am looking for but not quite in the format I would like.
I would like to display the data as ' Team Season - 18/17 0.514% '. Everything works now except the format of the percent, it showns up as ' Team Season - 18/17 0.514285...... '. Any ideas?Code:="Team Season - " & [Record] & " - " & Format("0.000%",[Wins]/[TotalGames])
Jim O
Last edited by JimO; 05-17-2016 at 05:44 PM.
Master of Nothing
Windows XP Access 2010 32bit
The format string and expression are reversed.
Not sure if it is the correct format string, but try
Code:"Team Season - " & [Record] & " - " & Format([Wins]/[TotalGames],"0.000%")
Competent Performer
Windows 10 Access 2010 64bit
Thank you for the help. I did have to add one correction, [Wins]/[TotalGames]/100. It is working fine now.
Jim O
Master of Nothing
Windows XP Access 2010 32bit
Great. Glad to be of help.
Format error (changes to string undesirably)
Format only part of a concatenated Control Source field
Pulling multiple repeating values into a concatenated string.
query is re-organizing data in a concatenated string
Posting Permissions
Reply With Quote