Recent content by sburlingame

Thanks! I did create the second column and used the Iif function and it worked!! Exactly what I needed. I had a feeling it would be a simple function, just needed to know the right one and where to put it. Thanks everyone for your help!

Well the trouble is (if I understand correctly) not sure if that will get the result I need. 1 person in this database has 3 fields for phone numbers (home, work, cell) plus a personal email and work email field. There is a mixture of private vs. public info for one person (ie: home is public...

I guess I haven't done that before.... I am pretty much self taught in Access, still learning. How would I do that?

unfortunately there wouldn't be enough space on the rest of the reports I run if I had separate columns for the private data as I run reports that show all of the information for internal use (most reports are this way for this specific data) This is the only report out of about 30 I need to...

I have a database set up for contact information and track private vs. public contact info by putting a P in front of the data (i.e. a private phone number is shown as "P - 555.444.3333" in the table) I am running a report to show any public data and need to know if there is a way to eliminate...