Yes, very much need to see the SQL, open the Query in design view, right click in an empty space next to the tables, select SQL View from the menu.
<CtrlV> to copy, return here, click on the [CODE/] format button and <CtrlC> to insert the copied text BETWEEN the two code tags.
When you say double do you mean:
Duplicate entries or do you mean the value multiplied by 2?
As for the double in the field, if what you mean is that you opened the table in design view, selected the field, in the grid next to the field would be "Numeric" and in the grid below you have "double," that means that the data type is numeric with a double size...
---
Introduction to data types and field properties
Every table is made up of fields (field: An element of a table that contains a specific item of information, such as a last name. A Title field might contain Mr. or Ms. Databases such as Microsoft SQL Server refer to fields as columns.). The properties of a field describe the characteristics and behavior of data added to that field. A field's data type is the most important property because it determines what kind of data the field can store. This article describes the data types and other field properties available in Microsoft Access 2010, and includes additional information in a detailed data type reference section
---
3
