Fields not showing on Report
in [General]
|
From: dstremmet on 7 Apr 2010 11:32 I have a report based on a query. When I add the fields to the report, some of my fields don't produce data.???? -- dks
From: Jeff Boyce on 7 Apr 2010 11:42 Post the SQL of the query. Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "dstremmet" <dstremmet(a)discussions.microsoft.com> wrote in message news:C0247D42-942E-49C1-8D29-D15941F4E35C(a)microsoft.com... >I have a report based on a query. When I add the fields to the report, >some > of my fields don't produce data.???? > -- > dks
From: Dorian on 7 Apr 2010 12:05 Is the query returning the data? If the query returns the data, make sure your report control is bound to the right column. What type of data is this (text, number,date etc.)? -- Dorian "Give someone a fish and they eat for a day; teach someone to fish and they eat for a lifetime". "dstremmet" wrote: > I have a report based on a query. When I add the fields to the report, some > of my fields don't produce data.???? > -- > dks
From: J_Goddard via AccessMonster.com on 7 Apr 2010 12:14 Hi - Run the query on its own, outside of the report. Do the fields have the required data when you do? John dstremmet wrote: >I have a report based on a query. When I add the fields to the report, some >of my fields don't produce data.???? -- John Goddard Ottawa, ON Canada jrgoddard at cyberus dot ca Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access/201004/1
From: dstremmet on 14 Apr 2010 14:11
The query returns the data, when I add the fields to the reports it shows blank. -- dks "Dorian" wrote: > Is the query returning the data? > If the query returns the data, make sure your report control is bound to the > right column. > What type of data is this (text, number,date etc.)? > -- Dorian > "Give someone a fish and they eat for a day; teach someone to fish and they > eat for a lifetime". > > > "dstremmet" wrote: > > > I have a report based on a query. When I add the fields to the report, some > > of my fields don't produce data.???? > > -- > > dks |