hide certain records on a report

  • Thread starter Thread starter sobeit
  • Start date Start date
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
 
i put a criteria on the yes/no field were .......not "yes" but an error pops
to limit the report to open
 
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
Click to expand...
[quoted text clipped - 18 lines]
Click to expand...
 
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


sobeit said:
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
Click to expand...
[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
Click to expand...
Click to expand...
Click to expand...
 
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

Jeff said:
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......:)
Click to expand...
[quoted text clipped - 8 lines]
Click to expand...
 
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

sobeit via AccessMonster.com said:
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

Jeff said:
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......:)
Click to expand...
[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
Click to expand...
Click to expand...
Click to expand...
 
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
Click to expand...
[quoted text clipped - 23 lines]
Message posted via AccessMonster.com
Click to expand...
Click to expand...
 
Back
Top