S SAC Dec 3, 2003 #1 I'd like to skip a record on a report if a condition isn't met. Something like: If txtCode < "B" then skip record. Thanks.
I'd like to skip a record on a report if a condition isn't met. Something like: If txtCode < "B" then skip record. Thanks.
F fredg Dec 3, 2003 #2 SAC said: I'd like to skip a record on a report if a condition isn't met. Something like: If txtCode < "B" then skip record. Thanks. Click to expand... Not sure what you're looking for here. Skip the record or skip the field? Do you mean something like not showing a field in the report? In the Detail Format event: txtCode.Visible = txtCode >= "B" Or moving completely to the next record? Look up: NextRecord MoveLayout PrintSection in VBA help. Open any code window and click help.
SAC said: I'd like to skip a record on a report if a condition isn't met. Something like: If txtCode < "B" then skip record. Thanks. Click to expand... Not sure what you're looking for here. Skip the record or skip the field? Do you mean something like not showing a field in the report? In the Detail Format event: txtCode.Visible = txtCode >= "B" Or moving completely to the next record? Look up: NextRecord MoveLayout PrintSection in VBA help. Open any code window and click help.
F Fons Ponsioen Dec 4, 2003 #3 I think you are looking skipping a record in a report. The symplest way would be to base the report on a query rahter than a table. In the query you can tell it in the criteria specify < "B" Hope this helps. Fons
I think you are looking skipping a record in a report. The symplest way would be to base the report on a query rahter than a table. In the query you can tell it in the criteria specify < "B" Hope this helps. Fons
