Solved

Whay does my quesy show "Expr1000"?

Posted on 2015-02-09
5
899 Views
Last Modified: 2015-02-12
When I run my query, I see afield that says "Expr1000"

I put an image attached.
EXPR1000.jpg
0
Comment
Question by:cssc1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 51

Accepted Solution

by:
Gustav Brock earned 250 total points
ID: 40599554
Because one field is included more than once.

/gustav
0
 
LVL 18

Assisted Solution

by:Simon
Simon earned 250 total points
ID: 40599558
It can mean you have used two columns with the same name in your output (e.g. if you picked 'Event' twice, either from the same table or two different tables) OR it can mean that you have a calculated column (e.g. [EventNo]-1) without specifying an alias for the calculated expression.

If the first is true, remove one of the duplicate columns from your output.
If the second is true, prefix the calculated expression with an alias, thus

MyColAlias:[EventNo]-1
0
 
LVL 30

Expert Comment

by:hnasr
ID: 40599601
Adding: (Access 2010)

If you have a field a:

For a calculated field (a + 1), access defaults to Expr1, Expr2, ...
Aliases are reflected in design view and sql view.

When adding a field more than once, then previous entries' aliases default to Expr1000, Expr1001, ...
The aliases don't show in design or sql views
0
 

Author Closing Comment

by:cssc1
ID: 40605526
Thanks
0
 
LVL 51

Expert Comment

by:Gustav Brock
ID: 40605529
You are welcome!

/gustav
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question