Question regarding make table function not displaying desired data type format

[tntsgoboom]

Hey all

I have two imported tables containing various amounts of data. What I am trying to do is take some data from each table and create a new table.

My issue is that when using make table after selecting the columns that I want the data it is outputting while technically correct is in decimal form and not percent. I need it to display in percent.

The table that I'm grabbing the data from has a data type of "Number" followed by, single, percent, decimal places 2. Why is it that once I run make table it switches it to decimal format?

I can manually change the new table to have it display in percent however I need it to be in percent the moment I run the query.

Thank you for any help provided.

[ranman256]

Don't use make table. You use append queries to add data to preFormatted table.
then use a Select query to pull the fields you want.

so in essence, you don't need the append query. Just the query to pull the needed fields from the source table..

[tntsgoboom]

The two tables that I am selecting data from will be updated daily and the query will need to be run daily. That is why I wanted to join the first two tables then select parts of those two and create a third table with the combined selected parts.

I think, correct me if I am wrong but if I were to use append the old data will still be in the new table and the new data will be added on top of that.

I essentially need a third new table to be created everyday that is a combination of the new daily data from the other two tables and in the same exact format. My issue is for whatever reason the third table when created is displaying the percentage data from the previous tables in decimal form.