Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-12-2019, 07:32 AM   #1
GBalcom
Much to learn!
 
Join Date: Jun 2012
Location: Georgia
Posts: 413
Thanks: 20
Thanked 4 Times in 4 Posts
GBalcom is on a distinguished road
Field values not showing for every record

I have a report that is based on a query. query shows all records for the field first name. I used the wizard to create the report, and not it is not showing the field value for every record. It appears to only show a value for the record if the value isn't the same as the previous record. Any idea how to fix this? Thanks!!

GBalcom is offline   Reply With Quote
Old 07-12-2019, 07:40 AM   #2
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 11,029
Thanks: 40
Thanked 3,578 Times in 3,456 Posts
CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light
Re: Field values not showing for every record

sounds like a setting in your report - probably your grouping
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
Old 07-12-2019, 08:53 AM   #3
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 7,610
Thanks: 59
Thanked 2,438 Times in 2,338 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Field values not showing for every record

or put your report in design view.
cick on the textbox that has an issue.
on its Property->Format->Hide Duplicates, change it to "No" if it is "Yes".

__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 07-12-2019, 05:01 PM   #4
GBalcom
Much to learn!
 
Join Date: Jun 2012
Location: Georgia
Posts: 413
Thanks: 20
Thanked 4 Times in 4 Posts
GBalcom is on a distinguished road
Re: Field values not showing for every record

Thanks guys, that was it.

GBalcom is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Report showing #error in Field Values on 2nd page GBalcom General 3 03-16-2017 11:14 AM
Field not showing values fleurette Reports 3 05-14-2013 01:42 AM
Showing 2 values separated by a '/' for a field on a form sachinvh Forms 1 08-07-2003 06:57 AM
Showing last record as default values Dominic84 Forms 1 08-21-2002 05:18 AM
[SOLVED] Combo Box on form is only showing form field values not linked table values thepitcrew Forms 1 11-29-2000 01:48 PM




All times are GMT -8. The time now is 09:09 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World