Search results

I have a query that when opened, opens a dialog box to type in what I am searching for. The problem is that I need to type in exact value in order to retrieve the record. Ex, if a field contains "BS - Psychology" and i search for "Psychology" then I will not retrieve that record. I must search...

I have a report that spits our several fields from a query. How can I add a button on the switchboard that opens a dialog box and allows the user to type in a keyword and then opens the report for all records that contain the keyword anywhere within the entire query?

I am running Access 2007 and have a report pulling data from a query in which a record may have several fields that are left empty. I need the report to display only fields that contain data and leave off the empty fields and labels that go with them. All lables beneath would also have to be...

Currently I have a querry pulling employee data from several tables (experience, education, awards, etc...). My problem is that if a record (employee) is on the experience and eduation tables but has no awards and is not on the awards table, then they will not be displayed in the query. I would...