 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / March 2008hide certain records on a report
how can i hide a certain record on my report Place criteria in the query used as source for the report.  SignatureKARL DEWEY Build a little - Test a little > how can i hide a certain record on my report an example sir wud be great thanks >Place criteria in the query used as source for the report. >> how can i hide a certain record on my report 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 > an example sir wud be great > > thanks > >>Place criteria in the query used as source for the report. >>> how can i hide a certain record on my report i put a criteria on the yes/no field were .......not "yes" but an error pops to limit the report to open >WHERE SomeID <> 17 > [quoted text clipped - 15 lines] >>>Place criteria in the query used as source for the report. >>>> how can i hide a certain record on my report 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 vague it is .......thank you......:) >Wow, you really ARE vague! What criteria did you put? What error popped up? >Evi [quoted text clipped - 4 lines] >> >>>Place criteria in the query used as source for the report. >> >>>> how can i hide a certain record on my report 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 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. > [quoted text clipped - 11 lines] >>>> >>>Place criteria in the query used as source for the report. >>>> >>>> how can i hide a certain record on my report 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] > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200803/1 thank you evi >Try > [quoted text clipped - 11 lines] >> Message posted via AccessMonster.com >> http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200803/1 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.