Good Afternoon,
I am using a Make Table Query to make a new table. The query pulls from a table where the data elements are formated as Number [DataElement] and [DataElement2]
The first thing I need to do is to convert [DataElement] and [DataElement2] as currency. then divide [DataElement] by [DataElement2] as a percent.
When it makes the table, it leaves the two data elements as numbers and the percent calc as a number or I've used Format([DataElement], "Currency") and the make table query, has it as text. Weird.
Start Free Trial
