Search results

Thanks for the responses. I have created a Union query which searches the 3 sectors for a value. Here is the coding below. SELECT CompanyReference, Company, Town, Postcode, CompanySector1, CompanySector2, CompanySector3 FROM Company WHERE CompanySector1= "IT" UNION SELECT CompanyReference...

Hello again! Im looking to create a user friendly query which will need to search 3 fields (Sector1, Sector2 and Sector3) and pull out resquested data. The 3 sector fields belong to a "Company" table. Each company can be asssigned up to 3 sectors e.g. Sector1 - IT, Sector2 - Marketing...

Thanks for the replies. The reason there are 2 tables is because each table contains additional columns (which I have not listed here as they were not necessary for this query) which are unique to each table. I will remove all spaces in column/table names and I will also rename the "Date"...

Firstly, thanks for the quick response. I will describe the structure of the 2 tables in more detail. Jobs Placed Table Jobs Placed Ref (Autonumber/PK) Company (Text) Date (Date/Time) Position (Text) Job Description (Text) Jobs Proposed Table Jobs Proposed Ref (Autonumber/PK) Company (Text)...

Hi all, Im looking to create a simple "To Do List" query in Access 2003. Basically I have 2 tables each containing the usual Reference/ID numbers as well specific fields for both tables. Each table also contains a "Date" field. Is there anyway I can produce a query which will display records...