Frequently Asked Questions

Can I add new fields to my tables?

Yes, you are free to add new fields to any table in your software. Add the new field in table design mode (for example, open DataSurveySense.mdb and go into design mode for tblEmployees). To add the new field to an Excel import file so that it imports automatically, use the same column name you assigned in table design. NOTE: You are free to customize an aspect of your software, such as table, query, form, and report design.

Why is my report or output spreadsheet blank?

Linking fields may not match up in your tables. Run the data integrity reports to find these types of errors in your data.

Why do my calculations appear to be incorrect in my Survey Sense reports?

Your weights aren't adding up to 1.0 for each job. Look at the detail report, not the summary report. There should be an error message after each job that doesn't add up to 1.0 (the error doesn't appear on the summary report). On Step One of Market Analysis there is a button called Sum of Weights. It gives you the sum of all your weights, which should be 1.0 for each job. Any that do not add up to 1.0 should be corrected.

I imported data, but cannot view the data on the screens.

Linking fields may not match up in your tables. Run the data integrity reports to find these types of errors in your data.

When importing Excel data, I receive an error message - Numeric Field Overflow. What should I do?

An easy fix is to add a new, first record to the beginning of the Excel file that has an "X" in each field.

When importing Excel data, I receive an error message - Key Violation Error. What does this mean?

This message is indicating you are trying to enter a duplicate record (two records with the same primary key). You may have duplicate records in the Excel file you're importing, or the records already exist in your software.

When importing Excel data, I receive an error message - Microsoft Jet Engine does not recognize F8 (or F11 or any other number) as a valid field name. What should I do?

Access is trying to import a column with no data in it and trying to give it its own field name. Copy and paste the Excel data to a new spreadsheet and/or delete 20 blank columns to the right of the data and 20 blank rows beneath the data to get rid of hidden data causing error messages. Also delete columns with headings but containing no data (this is particularly critical for the SurveyJobLevel column in Survey Sense).

When importing Excel data, I receive an error message - Unable to append all the data to the table. The contents of 0 record(s) were deleted, and 0 record(s) were lost due to key violations. What does this mean?

All records are appended to the table, but the contents of some fields may have been deleted. It may or may not be a concern. Look at the original file you were importing and try to identify why the message appears. If all data is clean, you should not get the message. There are several things you can try to eliminate this error message. Delete several blank columns and rows surrounding the data. Be sure to spell the column headings correctly. Delete columns with headings but containing no data (this is particularly critical for the SurveyJobLevel column in Survey Sense).