R razorking Registered User. Local time Today, 14:25 Joined Aug 27, 2004 Messages 332 May 28, 2009 #1 I have a table that has values that are data type test, My values in text look like this: 2.62 5.00 60.00 Is there a way in a query to format this text as a numeric percent of: 2.62% 5.00% 60.00%
I have a table that has values that are data type test, My values in text look like this: 2.62 5.00 60.00 Is there a way in a query to format this text as a numeric percent of: 2.62% 5.00% 60.00%
SOS Registered Lunatic Local time Today, 14:25 Joined Aug 27, 2008 Messages 3,512 May 28, 2009 #2 razorking said: I have a table that has values that are data type test, My values in text look like this: 2.62 5.00 60.00 Is there a way in a query to format this text as a numeric percent of: 2.62% 5.00% 60.00% Click to expand... You can use Format(Val([YourFieldName])/100,"percent")
razorking said: I have a table that has values that are data type test, My values in text look like this: 2.62 5.00 60.00 Is there a way in a query to format this text as a numeric percent of: 2.62% 5.00% 60.00% Click to expand... You can use Format(Val([YourFieldName])/100,"percent")
R razorking Registered User. Local time Today, 14:25 Joined Aug 27, 2004 Messages 332 May 28, 2009 #3 SOS, Good God! that works. And correctly as well. Easy enough. Thanks!
