ms access 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi.
I have three tables, from these 3 tables i want to produce a recordset with
the table fields i need. One of the conditions i need to set, is that if
there are records that have the same organisation ID no. then only select one
and put the rest into a new table or if there is more than 1 record with the
same organisation ID no. then make a new table and put those records in there.
Can anyone help please
 
thanks for your time - context of the problem - i need to mail out to people
within the database. The external mailers print from MS word only, so
therefore i need a mail merge in MS word and using data from MS access(this
is where all the data is).
The main problem is - each person (a record within the database) works for a
company, where there is a bunch of records that work for the same company
need to be merged on the same piece of A4 paper.
The reason why i wanted to separate tables according to company name, it
would then take just be a case of doing a mail merge for each table.
 
Then create a single employees table and add a field that identifies the
company. You could probably have a separate company table and simply store
an ID value for that company in the employees table.

tblCompanies
CompanyID
---Other fields related to a company

tblEmployees
EmployeeID
CompanyID (Foreign Key)
---Other fields related to an employee

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html
 
Back
Top