Re: missing field data in several records in a report

From: Jeff Boyce (JeffBoyce_IF_at_msn.com-DISCARD_HYPHEN_TO_END)
Date: 03/20/05 

Date: Sun, 20 Mar 2005 09:59:11 -0800

Pia

Oooh! That makes it a real puzzle!

Is there something different about the properties of the report controls
that DO display their data, when compared with those that DON'T? 

-- 
Good luck
Jeff Boyce
<Access MVP>
"Pia P" <PiaP@discussions.microsoft.com> wrote in message
news:98E2DC0A-79D9-4B5C-A772-4937039A314F@microsoft.com...
> Thanks for taking the trouble to reply Jeff. The report is based on a
query
> and the query returns all the required fields when run, so I don't think
this
> is the problem (but I could be wrong, still being a novice Access user).
> Interestingly, when I export the query result to MS word, all the values
are
> displayed correctly and no data is missing.
>
> "Jeff Boyce" wrote:
>
> > Pia
> >
> > Is your report based directly on a table, or on a query?  If a query,
what
> > does that query return when run?
> >
> > Is there a chance that any of the 'missing' data is from a field that
might
> > have blanks and other characters (i.e., a memo field)?
> >
> > -- 
> > Good luck
> >
> > Jeff Boyce
> > <Access MVP>
> >
> > "Pia P" <Pia P@discussions.microsoft.com> wrote in message
> > news:E340F339-D7E5-498E-8217-7C3029DF4DA7@microsoft.com...
> > > I'd appreciate any suggestions on solving this problem. When
displaying a
> > > report several of the records are missing data in one of the fields.
Other
> > > records display the data o/k and the field displays correctly in the
> > table,
> > > form and query. I have deleted the data and re-entered it, have
compacted
> > the
> > > database, redone the query and the report, all to no avail. Any
> > suggestions?
> >
> >

Relevant Pages

  • Re: Renaming field names of Linked Table in query
    ... this friendly name table and have those names appear when I run a query. ... "Jeff Boyce" wrote: ... Your forms can display whatever labels you want. ... in the query I could manually rename GLACT by ...
    (microsoft.public.access.queries)
  • Re: Dynamic Reporting based on Parameterized Crosstab Query
    ... The tek-tips solution does display the actual date on the report. ... on the first 3 rowwise fields of the crosstab query. ...
    (microsoft.public.access.reports)
  • Re: Query Logic dysfunctional
    ... SQL statement of your query(s), nor the data structure from which the query ... The baby's age as of the report date is <36 months or is null ... IFSP date is>= Eligibility Date ... "Jeff Boyce" wrote: ...
    (microsoft.public.access.queries)
  • Re: Problem with relationship??
    ... Have the SQL (or the query) refer to the form on which the user selects the ... "Jeff Boyce" wrote: ... Product] it will return ALL the products I have that require seriel ... Then you design a report, based on the data the query returns. ...
    (microsoft.public.access.gettingstarted)
  • Re: Same Parameters in all sub reports
    ... something wrong between the form and the query. ... It didn't for my regular queries. ... "Jeff Boyce" wrote: ... Build a query that will be used to provide data to your report. ...
    (microsoft.public.access.reports)