Access 2007 query

[BlackGranada]

Hello if there is help at hand , I am quite new to this.. I have forms, and
tables created with 70 employees that have up to 21 different training
certifications held that all differ in dates of expiry, trying to produce one
report for all that shows each persons certification held and when due for
expiry. what is the best way for me to do this. thanks

 

[John W. Vinson]

Hello if there is help at hand , I am quite new to this.. I have forms, and
tables created with 70 employees that have up to 21 different training
certifications held that all differ in dates of expiry, trying to produce one
report for all that shows each persons certification held and when due for
expiry. what is the best way for me to do this. thanks

By creating a Query joining your appropriately normalized tables.

If you would like help doing so please post a description of your tables and
indicate how they are related. Do note that tables are *fundamental*; forms
and reports are based on the Tables, not vice versa!

 

[Rich Wonneberger]

Steve,

What would happen if you had Joe Smith, and Tom Smith.
Both with multiple certs?
If the query had both fields sorted ascending would it keep each users
certs together?

Rich W.

 

[Rich Wonneberger]

Steve,

Thanks for the reply.
I see why they would be separate now.

 

[bigbolokbob]

hi everyone how do i find couples on here from uk

 

[Larry Linson]

This is a newsgroup for questions and answers about, or technical discussion
of, Microsoft Access database software. It is not a "friend-finder" group,
or a pen-pal group, or a swinger's group -- you'll not find any of those in
the microsoft.public... newsgroup hierarchy, which deals with Microsoft
products only.

Larry Linson
Microsoft Office Access MVP

 

[John W. Vinson]

hi everyone how do i find couples on here from uk

Well, not here on this technical support newsgroup for Microsoft Access
database software. Please look elsewhere - i.e. not on any of the Microsoft
technical newsgroups.