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: 410
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: 10,905
Thanks: 40
Thanked 3,538 Times in 3,419 Posts
CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice
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,195
Thanks: 57
Thanked 2,311 Times in 2,217 Posts
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: 410
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:00 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