Search results

Keith, Yes, ON and FD are in the same field, along with the other provinces, BC, AB, SK, etc. Right now the query correctly filters the results for each province, but in all cases (for each province) I want to include the records behnd FD as well. Im guessing my DB has thousands of flaws, lol.

I have a particlar form with a ButtonA and FieldA. When ButtonA is clicked, I want it to open up FormA ONLY if FieldA says "Regulatory". If FieldA says "non-Regulatory" I want ButtonA to open FormB. Any suggestions? Thanks! Warren

Hello All, I am new to Access, and having trouble figuring this out: I have a query, pulling data from several dirrent tables. The purpose of the query, in a nutshell, is to show me what government regulations are applicable to buildings in each of the provinces (Canada). (ie: I select a...

Some of the 'tasks' in the task field are more than 255 characters, and cannot be reduced any further. any ideas? Thanks again Keith! appreciate your help.

Thanks for the reply Keith. When I added 'Distinct' to the query, and try to run the report, I get the following error: Can't include Memo or OLE Object when you select unique values ([Data Question Details].TASK) The last bit being a table, and a field within that table.

Hi folks. I am very new to Access, so please forgive me...I am learning :) I am trying to manipulate a database that tracks government regulations, and their applicability to certain things around the building. For example, fire exits. Fire exits is assidned a number within the database. There...