Why is my Query returning double values?

[bgordon]

I have a simple query on just one table - quite basic.
I have imported the table from Excel - it kept leaving out 6 rows of data.

When in importing I put the first fields where I believed were the problem and indexed them with 'Yes - No duplicates'

That seemed to bring all the data but the values are doubling still.

I checked the fields on which the Query is based and noticed some were set to double - no idea if this relevant.

Many thanks,

[Rabbit]

We would need to see SQL for the query.

[zmbd]

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

---

[bgordon]

Hi,

Yes, I should have said Values x 2

Not available now but will load tomorrow