Search results

I'm using the Excel button in the Data section at the top of Access....

When exporting a report to Excel my Yes/No fields do not export. The Label nor the field itself exports. I am using the Table to create the report, not a query and sorting data within the report. I am an amature at Access so the more detailed your answer the better! Thanks!

MSAccessRookie: I tried your SQL Statement and am getting the same results.... thank you for your suggestion, any other help will be appreciated. Cindy

I'm still not able to accept you as a friend.... :( I don't know if I can attach for everyone to view on here or not. Any other suggestions as to how I can send you the database? Thanks Cindy

I'm trying to accept your friend request but it has an error on the page

Is there a way I can send you the database without going through this forum?

This is the SQL text: SELECT DISTINCT SPA.pkProjectID, SPA.PROJECTNUMBER FROM SPA INNER JOIN SPATASKS ON SPA.PROJECTNUMBER = SPATASKS.fkProjectID WHERE (((SPA.JOBTASK) Like "*" & [keyword] & "*")) OR (((SPA.WORKAREA) Like "*" & [keyword] & "*")) OR (((SPATASKS.STEPSOFTASK) Like "*" & [keyword]...

Thank you for the help..... I have changed my tables accordingly to your suggestions (field naming conventions) and have inserted the query into my database. I am not able to find all of the records with the "keyword". It is only giving me 8 out of 27 records with the keyword. Any further...

SPA Table ID primary key, Autonumber PROJECT NUMBER, text DATE, Date/Time JOB / TASK, text WORK AREA, text CLASSIFICATION, text SPA Task Table ID primary key, Autonumber PROJECT NUMBER, text STEPS OF TASK, text HAZARD/REACTION, text SAFE PLAN, text RESOURCES, text TASK ENTRY DATE, date/time...

I have a SPA table and SPA Task table - attached are screen shots of both tables..... (SPA = Safe Plan of Action) I'm wanting to search all fields in both tables which are used on one form and find a record that would have a particular word within any field. does that make sense?

I'm trying to create a macro that will look in two tables to find records. I have a form that has a sub-form and need to search for records within both tables. The problem is that I need to leave the "search for" blank until I have a particular word that I am looking for. The tables are...