hide certain records on a report

[sobeit]

how can i hide a certain record on my report

 

[KARL DEWEY]

Place criteria in the query used as source for the report.

 

[sobeit]

an example sir wud be great

thanks

Place criteria in the query used as source for the report.

 

[Jeff Boyce]

WHERE SomeID <> 17

(if you'll provide a more specific description of YOUR data, the newsgroup
readers may be able to offer more specific suggestions tailored to YOUR
data)

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[sobeit]

i put a criteria on the yes/no field were .......not "yes" but an error pops
to limit the report to open

 

[Evi]

Wow, you really ARE vague! What criteria did you put? What error popped up?
Evi

 

[sobeit]

vague it is .......thank you......

Wow, you really ARE vague! What criteria did you put? What error popped up?
Evi

i put a criteria on the yes/no field were .......not "yes" but an error pops
to limit the report to open

[quoted text clipped - 18 lines]

 

[Jeff Boyce]

As you've been reminded, we aren't there and can't see what you're doing.

If you don't give us more specific descriptions, we hard-pressed to offer
more specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

vague it is .......thank you......

Wow, you really ARE vague! What criteria did you put? What error popped
up?
Evi

i put a criteria on the yes/no field were .......not "yes" but an error
pops
to limit the report to open

[quoted text clipped - 18 lines]

Place criteria in the query used as source for the report.
how can i hide a certain record on my report

 

[sobeit via AccessMonster.com]

i have a checkbox field in my subform......when it is set to "true/yes".....
then that specific record will not show on my report
i put criteria in query of the report NOT "YES" but when i run the report a
message error pops saying
"this expression is typed incorrectly, or its too complex to be evaluated"

thanks sir Boyce

As you've been reminded, we aren't there and can't see what you're doing.

If you don't give us more specific descriptions, we hard-pressed to offer
more specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

vague it is .......thank you......

[quoted text clipped - 8 lines]

 

[Evi]

Try

Not True

in your criteria line and leave out the quote marks.
Had you given us this information immediately you would have had an
immediate response.

Evi

i have a checkbox field in my subform......when it is set to "true/yes".....
then that specific record will not show on my report
i put criteria in query of the report NOT "YES" but when i run the report a
message error pops saying
"this expression is typed incorrectly, or its too complex to be evaluated"

thanks sir Boyce

As you've been reminded, we aren't there and can't see what you're doing.

If you don't give us more specific descriptions, we hard-pressed to offer
more specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

vague it is .......thank you......

[quoted text clipped - 8 lines]

Place criteria in the query used as source for the report.
how can i hide a certain record on my report

 

[sobeit via AccessMonster.com]

thank you evi

Try

Not True

in your criteria line and leave out the quote marks.
Had you given us this information immediately you would have had an
immediate response.

Evi

i have a checkbox field in my subform......when it is set to "true/yes".....
then that specific record will not show on my report

[quoted text clipped - 23 lines]