Text field in Access query is blank

[pmaewatson]

I have been asked to do some work on an existing very simple Access table of
names and addresses plus some other info. Postcodes appear to be
straightforward text fields, and are printed correctly when I pull off
labels. However, when I set up a simple Select query on the table and include
the postcode, the postcode column is blank. Why would this be?

 

[KARL DEWEY]

Post your query SQL.

 

[pmaewatson]

Hi Karl

Thanks for your response. As you have probably guessed, I'm not much of an
expert in Access. I'm doing this work for a charity and they are not prepared
to let the database or anything to do with it leave the office. I'm not due
back there until next Monday. Can you give me a clue as to what to look for?

 

[KARL DEWEY]

Donna, do you have criteria in you simple select query?
Anything at all besides select and from?

 

[pmaewatson]

I tried it both with the Query Wizard and in Design view. It had no selection
criteria, just being sorted by surname. I'm not sure where to look to find
the actual query code.

 

[KARL DEWEY]

I'm not sure where to look to find the actual query code.
I think you mean the SQL of the query. Open in design view, click on VIEW
- SQL View , hightlight all in the window it opens, copy, and paste in a post.

 

[pmaewatson]

Thanks. Will do when I get the chance.

I think you mean the SQL of the query. Open in design view, click on VIEW
- SQL View , hightlight all in the window it opens, copy, and paste in a post.

 

[pmaewatson]

Query which is not working (generated by query wizard)

SELECT [FirstName], [LastName], [PostCode]
FROM [Headway information];

FirstName & LastName are shown but PostCode is not

 

[vanderghast]

There can be many possibilities.

I assume you see the data in a QUERY data view.

The most common one will be that there is no PostCode in the table, so none
would be displayed from the query.

Another possibility is that the PostCode start with blanks, (or carriage
return) and due to the vertical size of the display, you only see the first
line (blank). Try to enlarge the vertical size of each row (a little bit
like you would do within Excel) just to be sure that if there were multiple
lines, you would see them.

If you don't seven ee the field name, then enlarge the horizontal size of
the form displaying the query.


If you see the data from a form: do you see values under PostCode in query
data view? but not in the Form? it is possible that the form has not been
instructed to display the said field. Is there is a control for it in the
form detail section? is this control has something in its Control Source
property? The easiest way to display the field, in the form, is to open the
form in design view, and to drag the desired field from the Fields List
onto the detail section of the form.




Vanderghast, Access MVP

Query which is not working (generated by query wizard)

SELECT [FirstName], [LastName], [PostCode]
FROM [Headway information];

FirstName & LastName are shown but PostCode is not

I think you mean the SQL of the query. Open in design view, click on
VIEW
- SQL View , hightlight all in the window it opens, copy, and paste in a
post.