show records

B

bolson7117

hey guys,

how do i only show records that have text in them when i run the report.

dum ? i know

thanks,
 
B

bolson7117

bolson7117 said:
hey guys,

how do i only show records that have text or anything in them when i run the report and not the others that are empty?

dum ? i know

thanks,
Click to expand...
 
J

John Spencer

Apply criteria to filter out the records where the field value is null.

Is your report based on a query? a Table?

How are you calling the report? With VBA Code, by clicking on the
report and opening it?


'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
B

bolson7117 via AccessMonster.com

Its based off just a large table, yea im just running it strait from the
quire design window.



John said:
Apply criteria to filter out the records where the field value is null.

Is your report based on a query? a Table?

How are you calling the report? With VBA Code, by clicking on the
report and opening it?

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
hey guys,
Click to expand...
[quoted text clipped - 3 lines]
thanks,
Click to expand...
Click to expand...
 
J

John Spencer (MVP)

Well, first you really need to use a query as the source for the report so you
can apply criteria against the field.

Do you know how to do this? Do you need further help?

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
Its based off just a large table, yea im just running it strait from the
quire design window.



John said:
Apply criteria to filter out the records where the field value is null.

Is your report based on a query? a Table?

How are you calling the report? With VBA Code, by clicking on the
report and opening it?

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
hey guys,
Click to expand...
[quoted text clipped - 3 lines]
thanks,
Click to expand...
Click to expand...
Click to expand...
 
Top