Help with a report

[Guest]

I have a report that is based on a query and for some reason the data that is
in the table in one particular field does not show up in the query or the
report but does show up in the table and the entry form.

Can someone help me please.

 

[John W. Vinson]

I have a report that is based on a query and for some reason the data that is
in the table in one particular field does not show up in the query or the
report but does show up in the table and the entry form.

Can someone help me please.

Sure, if you'll help us. We can't see your report or your query, and know
nothing about the structure of your table.

Please post the SQL view of the query; describe what you're seeing or not
seeing; indicate the Control Source of the field on the report as well.

John W. Vinson [MVP]

 

[Guest]

If the column (field) has been added to the table since the query was
originally created you will probably have to update the query definition in
design view so that it returns the new column.

Another possibility is that the 'show' check box for the column in question
was inadvertently unchecked in query design view.

Ken Sheridan
Stafford, England

 

[Guest]

I apparently had group by on in the query, which this for some reason
limited what was showing in the query and the report. This resolved the
problem.

Thanks for your help on this matter.