Query shows data, some of the report fields are blank

  • Thread starter Thread starter Lilypat
  • Start date Start date
L

Lilypat

Access 2003. I've got a query that gives me a Product Description column, a
Year New column, an SKU sum column and 2006, 2007, and 2008 unit sales
columns. When I display the query results every field contains data. I've
created a report based on this query and while almost every field in the
report contains data, there are some sporadic fields in the Year New column
that are blank. Any thoughts as to why they show up in the query and not the
report?
Thanks
 
I would widen the control for that field a bit, and make sure the "Can Grow"
is set to Yes in the properties for it. I'd also look at data type - for
example, Date or Currency. Other than that, can't think of anything. Hope
this helps.
 
Back
Top