Search results

I changed the "NAME" field to "FULLNAME." If this cannot be done in the manner abover, is there a better way to combine these fields and still have them appear in a dropdown box for easy selection? I am completely stumped...

Okay, I think I have the calculated query done accurately as it returns the correct response when running the query. When I add that field to my form, it yields a blank dropdown box.

Sorry, I do not understand how to do this. I have not idea how to add a calculated query. For my form, I have a field named "NAME" that is: =[SALUTATION] & " " & [FIRST NAME] & " " & [MIDDLE INITIAL/NAME] & " " & [LAST NAME] & " " & [SUFFIX] and this returns the complete name. Can I use...

Excellent! Thank you!

I have a simple form that separates the salutation, first name, middle initial, last name and suffix into different fields for sorting reasons. In the form itself I have a unbound field with a formula that joins all the names together so they appear as one complete name. Is there a way I can...

Yes, the check boxes are based off actual fields in the underlying table.

Hello. I am new at Access 2003 and I am trying to create a simple query as follows: The query is connected to a form that has 3 checkboxes. The results of the query will help generate a report. At worst, I would like the query to return ALL records where ANY of the checkboxes are empty. At...