M mazer New member Local time Today, 20:11 Joined Aug 19, 2005 Messages 8 Oct 6, 2005 #1 Can anyone tell me if the % sign can be used, and if it cant is there any other way around this?
R Rich Guest Oct 6, 2005 #2 Yes of course it can be used, maybe if you actually told us what the problem was we'd be able to help
Yes of course it can be used, maybe if you actually told us what the problem was we'd be able to help
M mazer New member Local time Today, 20:11 Joined Aug 19, 2005 Messages 8 Oct 6, 2005 #3 I have a column for sale info, which has 25% off in it, I created the table in excel and when I transfer the table to access I get errors in that column
I have a column for sale info, which has 25% off in it, I created the table in excel and when I transfer the table to access I get errors in that column
R Rich Guest Oct 6, 2005 #4 the value is actually .25, access will display that as 25% if you want it to
M mazer New member Local time Today, 20:11 Joined Aug 19, 2005 Messages 8 Oct 6, 2005 #5 How do I get access to display the percentage sign? Thanks for the help
S ScottGem Registered User. Local time Today, 15:11 Joined Jun 20, 2005 Messages 1,119 Oct 6, 2005 #6 mazer said: How do I get access to display the percentage sign? Thanks for the help Click to expand... Format the field, control, and/or query column for Percent. The Format property is in the Format tab of the Properties dialog for the object.
mazer said: How do I get access to display the percentage sign? Thanks for the help Click to expand... Format the field, control, and/or query column for Percent. The Format property is in the Format tab of the Properties dialog for the object.
P Pat Hartman Super Moderator Staff member Local time Today, 15:11 Joined Feb 19, 2002 Messages 47,578 Oct 6, 2005 #7 As Scott said, use the format property for the object. Do NOT use the Format() function to do the formatting. That will convert the value to a string.
As Scott said, use the format property for the object. Do NOT use the Format() function to do the formatting. That will convert the value to a string.
