When I print the table I want certain rows not to appear on some criteria

in my case rows that have one column field < 200 hours.

how can I do that?

Either base the report on a query that selects the appropriate records, or use a technique like this:

http://www.baldyweb.com/wherecondition.htm

but with a wherecondition like:

"FieldName < 200"

Either base the report on a query that selects the appropriate records, or use a technique like this:

http://www.baldyweb.com/wherecondition.htm

but with a wherecondition like:

"FieldName < 200"

I need my filter to affect only the DETAIL part of the report, the rest should still be based on the original query.

I just fixed this by making my rows field.invisible = true because rows that I dont need are at the end of the table anyways, i can just make them invisible. but now since it report treats them as they exist anyways, it spills to the next page and I have extra blank pages?

How can I say something, if page doesnt contain field.invisible = true please dont create such?

please help!!!:confused::eek:

Or in other words, how can I say that if row field.hours < 200

then ignore all the rest rows and go to the next report in the query?

Maybe some sample data would help us understand what you've got. Normally you exclude data from the report, not try to hide it.

Maybe some sample data would help us understand what you've got. Normally you exclude data from the report, not try to hide it.

In my upper portion of report I want no filter to be applied

but in the lower part where table is generated I want to apply filter i.e rows that only have more than 200 hours.

Previously I applied more than 200 hours filter to the QUERY that I am basing my report on.

but then some of the information in the upper portion of the report was missing. Thus I need to apply filter only to the DETAIL part of the report section.

to make it simple,

how can i make field on the report not show up at all instead of just saying field.visible = false

You can try hiding the detail section, as appropriate, in the detail format event:

Me.Detail.Visible = False

You can try hiding the detail section, as appropriate, in the detail format event:

Me.Detail.Visible = False

I dont want that because it is actually there and the table spills over to the next page but doesnt show anything and I have extra blank page.

I need it really skip the row, not just make it invisible.

Can we get a sample db? I'm having trouble visualizing what you're trying to do.

Can we get a sample db? I'm having trouble visualizing what you're trying to do.

I cant. work security issues.

I just need to find out how can I do something like

field.visible = true

but instead something like

field.skip = true

so it doesnt really have it on the report (wont take space unlike visible = false does)