Complex query help

  • Thread starter Thread starter Mickie
  • Start date Start date
M

Mickie

First and foremost, thank you for looking at my post and for giving
any and all help!

I have a an access database currently with two tables in it; the first
table is called Employees and contents a list of Employee's Last Name,
First Name, and Birth Date. The second table contains the same
information including a lot more; it is called UPDATEDL. This
database was imported from a DBF file into the access table name
UPDATEDL.
What I need to do is compare the Employees table against the UPDATEDL
table and find Employee's name (last, first and birth date) that match
in both tables. Once a match is found I would like to run a report to
print out the results. I would like this to be done by just clicking
a button in a Access form and the user would not need to do anything
else.

Thank you for any input,
Mickie
 
First and foremost, thank you for looking at my post and for giving
any and all help!

I have a an access database currently with two tables in it; the first
table is called Employees and contents a list of Employee's Last Name,
First Name, and Birth Date. The second table contains the same
information including a lot more; it is called UPDATEDL. This
database was imported from a DBF file into the access table name
UPDATEDL.
What I need to do is compare the Employees table against the UPDATEDL
table and find Employee's name (last, first and birth date) that match
in both tables. Once a match is found I would like to run a report to
print out the results. I would like this to be done by just clicking
a button in a Access form and the user would not need to do anything
else.

Thank you for any input,
Mickie
Click to expand...

Actually pretty simple.

Create a new Query. Add both tables to it. Drag the FirstName field from one
table to the FirstName field in the other, then do the same for LastName, then
for Birthdate. Select whatever fields you want to see in the report.

Now create a Report - for starters you can use the Report Wizard, or you can
create a new blank report in the designer and use this query as the
Recordsource. If you have a switchboard you can put a button on it to launch
the report, or you can create a little unbound Form and use the toolbox wizard
to create a form to launch the report.

Here are some possibly useful resources:

Utter Access discussion forum and resources:
http://www.utteraccess.com

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials


--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com
 
Back
Top