I have a table with fields defined with a percent format and zero decimal positions. After I run the query that populates this table and I open the table, everything look fine; no decimal positions. If I run the query that selects the records in the table everything looks fine; no decimal positions. BUT,the user user wants the data output to a Excel file and when I do that the same fields that had zero decimal postions in the query results now have 2 decimal positions in the Excel file. I'm at a loss....
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Output to Excel with percentages that should have zero decimal positio 1
- Thread starter KimmieB
- Start date
-
1
- #2
flyover789
Programmer
try using the round function in your query:
HTH,
fly
[blue]Typos, that don't affect the functionality of code, will not be corrected.[/blue]
Martin Serra Jr.
[blue]Shared Database_Systems and _Applications across all Business_Areas[/blue]
Code:
Round([YourPercentageField];0)HTH,
fly
[blue]Typos, that don't affect the functionality of code, will not be corrected.[/blue]
Martin Serra Jr.
[blue]Shared Database_Systems and _Applications across all Business_Areas[/blue]
- Status
Similar threads
- Locked
- Question
