Query shows data, some of the report fields are blank

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
 
M

Mary

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need some PWA help 0
Template with fields and premade texts.. 0
Cross Tab Report Vs Dynamic coulmns 0
Creating a Chart on form from selected data in query. 0
Some mail merge fields not pulling into document 2
Query to show details of dataset when one type of data is still blank 1
Report based on query shows no data 1
Data in a Query not populating in Report 3

Top