Search results

Hi Brian, If I have the following data in my table: Name Office Title Erik Phoenix ITGuy Bill Las Vegas Accountant Jim Salt Lake Engineer John null Accountant Fred Phoenix null Using my form with 3 controls, if I leave Title and...

Hi Galaxiom, Actually, I was talking about nulls in the fields (within the table) and not in the controls on the form. Which is why I was (maybe still am a little) confused as to how Brian's suggested changes are actually working because it doesn't ever seem to test the fields in the table for...

Well it makes a little more sense when you say it that way. Not how I would have ever thought to do it on my own. Thanks again.

Thanks for the explanation. I *think* I understand it. Either way, it's working as I would expect it and that's all that matters at this point. Now lets see if I can translate all that into my real database. Thanks to each of you for taking the time to offer help! Erik

Appreciate the help guys. Galaxiom - when I tried your suggestion of adding the extra column with the derived field, when I hit the button to run the query it now pops up a window asking me to enter a parameter for the First Name field. Always. I just hit enter (leaving it blank) and the...

Thanks Galaxiom. Where exactly does that bit of code go when creating the field? Apologize for my ignorance.

Thanks Galaxiom. I had tried that earlier but when I add the "Or Is Null" to the end of each of my 3 Like statements (because there could be null value in any of those 3 fields) if I search for something like all employees in one office it will return all records with the office value equal to...

Well I appreciate the help but don't go nuts trying to figure it out. After more research, I believe I'm having the exact same problem as the person in this thread. Well, I guess I can't post threads but it's thread id 243518, if you can figure out how to access it another way. It's showing up...

Sorry...assumed that was a typo. Tried Iff and got same error message "Undefined function Iff in expression...". Edit: Okay...I saw your original email said "IIF" so I changed it to that and it works. Sorta. It works in that one scenario but it's broken other functionality...say if I wanted to...

Thanks for the reply, rzw0wr. I'm confused about the 2nd part. Are you saying in Design View of the query at the top of the Job Title column (the Field row) I should add the code you suggested? If so, I tried that (as well as removing the portion you said) and it errored out with "Undefined...

Hello, I'm new here and relatively new to Access 2010. I've had to learn it at work because our DBA was let go and I was the only one willing to give it a go. Read a book or two and picked up some stuff on the internet. Here's my problem: I have a simple table -Employee with 4 fields...