Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2418
  • Last Modified:

Access Query Expr1001

I have an access Table.
In the table
The second field RefNo is a text field 50 - not required - allows zero length.

I have this in a Select Query
Inthe Design View of the query RefNo shows correctly.
When I look at the details (ordata) View RefNo shows as Expr1001

Any ideas why please?
0
johnhardy
Asked:
johnhardy
2 Solutions
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
>View RefNo shows as Expr1001
The most common answer is because you have this field in your query twice.  The first one is named correctly, the second one is named Expr1001.

Hope this helps.
-Jim
0
 
jrb1Commented:
Open up the query, and go to Vew "SQL View".

You should see a function of some sort with "as Expr1001".
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
If you are using the asterisk ( * ) to view all fields in a table, and specifying this field as well, then you'll have it in there twice.  
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
johnhardyAuthor Commented:
Such a quick and correct set of answers many thanks.

I trust splitting the points os OK

Regards

John Hardy
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Split 'em as you see fit.  Experts collaborate on answers all the time.  Good luck with your project. -Jim
0
 
ganesh mgCommented:
"Expr1001" is displaying at fields which is already declared for example "Address" that shows like "Expr1001" while declaring duplicate field name "Address".
Note:
1).Address field was created in table.
2).Create same field"Address" using Aliase "Address" then previous field name change as "Expr1001".
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now