Dan (Plank),
Thank you SO MUCH for your help. You don't know how much I appreciate it! Wahoo! So it could be done in a query after all! It worked great for me.
Thanks again,
-tattie
Hey Plank,
I need some additional guidance from you on your suggestion of entering IIF([boolean field]='yes',[emailaddress],"") into my query. I tried adding it to my current query in Design View, in the criteria field for the boolean field, but that doesn't work. I get a "data type mismatch"...
Hi,
Your suggestion will work. Thank you for the idea! I should have thought of that, but I was hoping for a query/subquery way of doing it.
Thank you!
-tattie
Hi,
Thanks for your reply. I know how to restrict records in a query, but what I'd like to know is if there's a way for a query to limit one field (the email address) from a specific record in the table from appearing? Or any other method in Access other than coding? Besides the fact that I...
Hello everyone,
The answer you've been waiting for (sorry) is that I currently do not note in the database which parents don't want their email address listed in the "Parent Directory" report. I simply have the paperwork the parents filled out when they provided their email address, specifying...
I should add that this is a very small database for a very small private school with no more than 100 students/records. It's in Access 2000. Hope this info helps.
I'm not a programmer, and have never done any coding in Access. For parents who don't want to appear AT ALL in the Parent Directory, I tell my query to not include their records. Is coding the only way to accomplish this? I'd like to keep the database as simple as possible.
Thank you for...
Hi,
No, I don't have a yes/no checkbox for that. Is there a different way of restricting a field from appearing? Can it be done in a query?
Thanks,
Robyn
Hi,
I need help in figuring out how to hide one field in a report for only specific records, not all records. The report is a school's Parent Directory, where some parents don't want their email addresses on it, but everyone else does. The email address is used for those parents on other...
Regarding the problem of the page setup not retaining itself, I have experienced this same problem repeatedly when running Access 2000 on Windows 98 PC's. After installing Windows XP Professional on those same PC's, Access 2000 never again exhibited those problems with the page setup. That...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.