Re: Text field in Access query is blank
- From: "vanderghast" <vanderghast@com>
- Date: Mon, 6 Jul 2009 10:06:11 -0400
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
"pmaewatson" <pmaewatson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:944AA3B2-CA51-45C9-8BA4-3EE40F5ABB0B@xxxxxxxxxxxxxxxx
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'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" wrote:
> 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" wrote:
>
> > Donna, do you have criteria in you simple select query?
> > Anything at all besides select and from?
> >
> > "pmaewatson" wrote:
> >
> > > 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" wrote:
> > >
> > > > Post your query SQL.
> > > >
> > > > "pmaewatson" wrote:
> > > >
> > > > > 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?
.
- References:
- RE: Text field in Access query is blank
- From: pmaewatson
- RE: Text field in Access query is blank
- Prev by Date: Pictures won't stay in form -Access 2003
- Next by Date: Re: how sum values with comma?
- Previous by thread: RE: Text field in Access query is blank
- Next by thread: Pictures won't stay in form -Access 2003
- Index(es):
Relevant Pages
|
