marseneault
Registered User.
- Local time
- Today, 19:46
- Joined
- Jan 11, 2019
- Messages
- 24
Hello,
So I started creating a data base that has a number of calculated values to get Profit, Margins and Overhead.
The Excel Spreadsheet that I get the data from includes decimal points, however, when I imported the data, it created it to be a long interger.
Since Integers do not have decimal points, many of my calculated values are not accurate and I have Tables, Querries and Reports that All use this data.
I tried changing the data type in my tables, querries and reports but now I my report shows an error and will not run.
I would have thought that by following the trail and updating all the data types to be the same would have fixed the issue, but it has not. Any ideas on how to repair this?
So I started creating a data base that has a number of calculated values to get Profit, Margins and Overhead.
The Excel Spreadsheet that I get the data from includes decimal points, however, when I imported the data, it created it to be a long interger.
Since Integers do not have decimal points, many of my calculated values are not accurate and I have Tables, Querries and Reports that All use this data.
I tried changing the data type in my tables, querries and reports but now I my report shows an error and will not run.
I would have thought that by following the trail and updating all the data types to be the same would have fixed the issue, but it has not. Any ideas on how to repair this?