473,395 Members | 1,495 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

Expr1005 Replaces Field Title In Query

1
I have a simple query that puts "Expr 1005" in one of my columns instead of the title I have chosen. It is only a text field and there are no calculations in this field so I am confused. Any ideas?
Oct 9 '14 #1
2 3247
Seth Schrock
2,965 Expert 2GB
Please post the whole SQL code using code tags (the [CODE/] button at the top of the text window) so that we can see what is wrong.

Off the top of my head I would say that you probably have duplicated a field name somewhere.
Oct 9 '14 #2
zmbd
5,501 Expert Mod 4TB
Off the top of my head I would say that you probably have duplicated a field name somewhere.
Survey Says: Number One Answer!

Second is the use of a reserved word/token as Acc2007 and newer will "help" you by changing the name to the generic Expr ####.
Oct 10 '14 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Norbert Lieckfeldt | last post by:
MS Access 2002 here. I am just trying to set up a simple database for a friend who's an optician. Basically, all clients with address details, date of last eyetest and a drop-down combo box to...
6
by: Larry R Harrison Jr | last post by:
I have a database I'm designing in Access 97. I have a custom field in a query which looks in {Table of Documents} and shows them all. It then needs a "latest revision number," stored in another...
1
by: Giloosh | last post by:
Hello i have been trying to figure out this problem for a very long time now, and thought maybe its worth asking for some help. I want to figure out if there is a way to create a field in a...
2
by: psuaudi | last post by:
I have a table that creates a value in the field using the now() function. The data stored, of course, is in the format of 12/4/06 12:44:00 PM. I would like to make a query that uses only the...
2
by: blux13 | last post by:
I am having problems with a memo field in my queries. At first it was fine, but I tried to do a count on a different field in the query, and now the memo field in all my queries come up in chinese....
5
by: Genalube | last post by:
I am trying to count the number of owners that show up in a query (conveyQuery). The query will produce a column OwnName that will contain names like John Smith, Mike Jones, Frank Vaugn. Each of...
2
Ericks
by: Ericks | last post by:
Why is it that a table's Memo field in a Query behaves like a Text field, showing only the first 255 characters when using the Totals option. When turning off the Totals options all text is shown. I...
9
by: Rotorian | last post by:
Good Morning, I have a table which has a "Date" field and a "Time" field. The "Date" field is format "Short Date" with a default value of "Date()" The "Time" field is format "Short Time" and the...
17
reginaldmerritt
by: reginaldmerritt | last post by:
I have an OpenForm with a where statement which throws up an error because the form i'm trying to open uses a query which has two fields from different tables sharing the same name. Let me explain...
1
by: Ahmedamer | last post by:
I prepared form for query but I do not know how to add one field from query to form.
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.