Make Table Question

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

Hi All,

When tested without making the table my make table query returns numbers in
the correct percentage format but in the 'made' table they appear as
decimals.

With the 'made table' being deleted and replaced how can I make the figures
appear in the percentage format that I need?

Ta.
Bill
 
Put Format(YourFieldName, "Percent") in one of the columns of your
query.

Hope that helps!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Restrict percents so they will not show decimal (i.e. 61% not 61.2 1
Make Table Query - Formatting Percentages 3
adding a field in a make table query 5
Make table query: [Enter 1] AS Test 1
IIf 1
maximum query 2
Percent total 101%! 1
Control Select Query Output Field Type 8

Back
Top